TryCF Gist

trycf-gist-1669137193431-486fffac-e414-18e7-53d3-bbe8f63bb8f1.cfm

<cfset Query1 = QueryNew("Fruit")>
<cfset QueryAddRow(Query1, 2)>
<cfset temp = QuerySetCell(Query1, "Fruit", "Apple", 1)>
<cfset temp = QuerySetCell(Query1, "Fruit", "Orange", 2)>
<cfset Query2 = QueryNew("Fruit")>
<cfset QueryAddRow(Query2, 2)>
<cfset temp = QuerySetCell(Query2, "Fruit", "Apple", 1)>
<cfset temp = QuerySetCell(Query2, "Fruit", "Pear", 2)>
<cfquery dbtype="query" name="Query3">
	SELECT Fruit FROM Query1
	UNION
	SELECT Fruit FROM Query2
	ORDER BY Fruit
</cfquery>
<cfoutput><cfdump var="#Query3#"></cfoutput>