I would like to create a query using both UNION and GROUP BY.
I plan to combine to tables, then perform a group by on the combination. How
do I do this?
I have only managed to do a group by on the individual tables then combine
them, but I want to combine the tables first then do a group by.
Can somebody please help me.
Darren Gilbertson
[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
