Combining two queries to one

[Guest]

I have two queries and I would like to output the results as one and sort by Name ASC

Any help would be great thanks

[wmanu]

Either use union in your SQL query or use Coldfusion to combine exisitng queries and create a new query resultset.

Something like this:

<CFQUERY NAME="getDetailsQuery1" DATASOURCE="#DSNNAME#">
SELECT * FROM getDetailsA
</CFQUERY>

<CFQUERY NAME="getDetailsQuery2" DATASOURCE="#DSNNAME#">
SELECT * FROM getDetailsB
</CFQUERY>

<CFQUERY NAME="getDetails" DBTYPE="query">
SELECT * FROM getDetailsQuery1
UNION
SELECT * FROM getDetailsQuery2
ORDER BY Name ASC
</CFQUERY>

Hope this helps!

Cheers / Manu.