Query of Queries Query 1 <cfquery name="Parts1" datasource"MyDb"> SELECT Apples, Oranges FROM tbl_Fruit </cfquery>
<cfquery name="Parts2" datasource"MyOtherDb"> SELECT Apples, Oranges FROM tbl_ArchivedFruit </cfquery> <cfquery name="AllParts" dbtype="query"><!--- Note the dbtype ---> SELECT Apples, Oranges FROM Parts1 <!--- Note the From is the CFQuery name ---> UNION SELECT Apples, Oranges FROM Parts2 SORT BY Apples, Oranges </cfquery> Works in CF5+, but the complete SQL set is not supported. HTH >>> [EMAIL PROTECTED] 10/27/03 1:21 AM >>> Is there an easy way to join two query objects together? (both have same structure) I tried StructAppend to no avail... - tim --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ ---------------------------------------------------------------------- Maddocks Melbourne - Tel: (61 3) 9288 0555 Fax: (61 3) 9288 0666 Sydney - Tel: (61 2) 8223 4100 Fax: (61 2) 9221 0872 Web: http://www.maddocks.com.au ---------------------------------------------------------------------- The information in this electronic mail is privileged and confidential, intended only for use of the individual or entity named. If you are not the intended recipient, any dissemination, copying or use of the information is strictly prohibited. If you have received this transmission in error please delete it immediately from your system and inform us by email on [EMAIL PROTECTED] ---------------------------------------------------------------------- --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
