I am using MS Access database. I have a table (Proposal) with the following properties: ProposalID - PK, Title, RequestedAmount, ResearcherID - FK
I want to run an SQL query to get the candidate that has requested for the highest amount. My query that didn't work is:
Select ProposalID, Title, Max(RequestedAmount) AS Budget, ResearcherID From Proposal;
I get this error:
You tried to execute a query that does not include the specified expression 'ProposalID' as part of an aggregate function
How can I fix this?