Hi All,
Basically how can I get around the GROUP BY rule of having column names in both SELECT and GROUP BY clauses?
I have a query that needs to display two key fields, a field that shows a MAX amount for each category, and also the 2 other supporting fields. My problems is getting the 3 supporting fields to show since GROUP BY only lets me display the aggregate field and the fields used to group. I think some type of JOIN...