ColdFusion : Inner join two Query of Queries

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>