<CFQUERY NAME="query3" DBTYPE="query">
SELECT *
FROM query1
UNION
SELECT *
FROM query2
</CFQUERY>
HTH
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 5, 2003 18:34
To: CF-Talk
Subject: RE: Concatenating Queries
Ok it looks like UNION is the answer. Can someone give an example? I can't
find it in the my SQL docs.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:33 PM
To: CF-Talk
Subject: RE: Concatenating Queries
union?
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:23 PM
To: CF-Talk
Subject: Concatenating Queries
Does anyone know of an easy way to concatenate two queries?
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
