joining two queries
hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: joining two queries
http://www.cflib.org/udf.cfm?ID=1021 _ From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 17:14 To: CF-Talk Subject: joining two queries hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: joining two queries
i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... http://www.cflib.org/udf.cfm?ID=1021 Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: joining two queries
My question would be Why do it in CF if you can do it in SQL? IMHO it's always best to make the DB do the work it's meant for...it does it best So I'd suggest using a UNION clasue to join the 2 queries.As you stated, there are 2 select lists with the same columnsso you should be good to go if your DB can handle UNIONs But hey...perhaps I'm not gettin what you're after Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Ryan Mitchell To: CF-Talk Sent: Tuesday, August 10, 2004 9:13 AM Subject: joining two queries hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]