XML to query with inner join

You can effect an inner join using ANSI SQL syntax:

Assuming you have two queries to join, Query1 and Query2, and both tables have a common column "JoinCol" (it's not actually necessary for the column to be named the same in both tables as long as the data relates), you can do:

<cfquery name="JoinQuery" dbtype="query">
     SELECT Query1.Col1, Query1.Col2, Query2.Col1, Query2.Col2
     FROM Query1, Query2
     WHERE Query1.JoinCol = Query2.JoinCol
       AND {some other optional criteria here}
</cfquery>

If you have three queries to join, and the join between Query1 and Query2 is different from the join between Query2 and Query3, then something like this:

<cfquery name="JoinQuery" dbtype="query">
     SELECT Query1.Col1, Query1.Col2, Query2.Col1, Query2.Col2, Query3.Col1, Query3.Col2
     FROM Query1, Query2, Query3
     WHERE Query1.JoinColA = Query2.JoinColA
       AND Query2.JoinColB = Query3.JoinColB
       AND {some other optional criteria here}
</cfquery>

HTH,

-Carl V.