I seem to recall someone suggesting creating a VIEW based on your selects
and union, and then selecting and grouping from that. Of course, you can't
do this in Paradox. The equivalent (sort of) would be to use a temporary
table.
Regards,
Andrew Cooke.
> -----Original Message-----
> From: Darren J Gilbertson [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 19, 1999 7:44 AM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Groupby after merging two tables
>
> 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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
