[DUG-DB]: Groupby after merging two tables

[Darren J Gilbertson]

I have asked this one before but got no response.

How can I merge to paradox tables together, then group them

Merging is easy by using UNION but the groupby can only be done on
individual SELECT commands.

Can I group a query of a query perhaps?


Darren

---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz