Inner Join two query of queries ( not the query pulling data directly from database ).
Say you have Query of Query A and Query of Query B. You want to inner join both query of queries on columns ID.
<cfquery name=”result” dbtype=”query”>
SELECT
*
FROM
QueryA, QueryB
WHERE
QueryA.ID = QueryB.ID
</cfuery>