Chief here,
First your asking a VERY broad question, try to narrow it down next time.
Now are your tables related? if they arent then you will need two <CFQUERY> statements.
If they are related, you can refer to them through a join. Now this can be an inner join,outer join, or another that...