<!--- Query the Girl queries from the different data sources and union them together. Since we don't actually want to eliminate any records, use UNION ALL. ---> <cfquery name="qGirlBoth" dbtype="query"> ( SELECT AGE, HAIR, NAME FROM qGirlOne ) UNION ALL ( SELECT * FROM qGirlTwo ) </cfquery>