Also, depending on the database you're using you might look into doing a
UNION select through the SQL itself.
> -----Original Message-----
> From: Tim Painter [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 10:24 AM
> To: CF-Talk
> Subject: Re: Concatenate 2 Queries
>
>
> If you are using CF 5, you can use UNION with the new Query of a
> query to do
> that.
>
> <cfquery name="Query3" dbtype="query">
> Select foo from Query1
> UNION
> Select foo from Query2
> </cfquery>
>
>
> ----- Original Message -----
> From: "Ken Monroe" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 10:00 AM
> Subject: Concatenate 2 Queries
>
>
> Hello!
>
> Is there a way to combine (concatenate) 2 different queries
> *without* using
> the QueryNew, QueryAddRow, QuerySetCell stuff? Something like
> QueryCat(Query1, Query2). ??
>
> Thx
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
