New answers tagged ms-access
1
You can use MySQL Workbench to connect and migrate your schema/data from MS Access to mySQL.
First you need to configure an ODBC Data Source:
Click Start, and then click Control Panel.
In the Control Panel, double-click Administrative Tools.
In the Administrative Tools dialog box, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog ...
0
If you want to use aggregated fields with not aggregated fields you will have to use Group by with the not aggregated fields.
But in your case IMHO you are searching for:
Select ProposalID, Title, RequestedAmount AS Budget, ResearcherID
From
Proposal
where RequestedAmount=(Select Max(RequestedAmount) from Proposal)
1
Yes there are significant benefits to data normalization if you are willing to do the work to achieve and maintain it. The two fundamental benefits to normalization are:
Data Integrity
Query Flexibility
The simple approach to normalization is to create a table for each person, place, thing, concept, or event. By doing this, you have each ...
Top 50 recent answers are included
