<!--- Join both queries using an outer join (no "ON" where clause defined and no column to match on). Grab all columns from the first query and only ONE column (the one we are adding) from the second column. ---> <cfquery name="qThree" dbtype="query"> SELECT qOne.*, qTwo.number FROM qOne, qTwo </cfquery> <!--- Output the resultant cartesian product. ---> <cfdump var="#qThree#" label="Query of Queries Method" />