TryCF Gist

trycf-gist-1568379329292-3e4f8fab-79d2-598d-dc60-517c5d0b0d6b.cfm

<cfdump var=#server.lucee.version#>
<cfloop list="numeric,integer" item="d">
	<cfoutput><h1>#D#</h1></cfoutput>
	<cfscript>
		a = queryNew("id","#d#");
		QueryAddRow(a);
		QuerySetCell(a,"id",1);

		QueryAddRow(a);
		QuerySetCell(a,"id",2);

		QueryAddRow(a);
		QuerySetCell(a,"id",3);

		b = duplicate(a);
		dump(a);
		dump(b);
	</cfscript>

	<cfdump var=#getMetaData(a)#>
	<cfdump var=#getMetaData(b)#>
	<cfquery name="q" dbtype="query">
		SELECT 	a.ID, b.id
		FROM 	a,
				b
		where 	b.ID=a.ID
			and b.ID IN (2)
	</cfquery>
	<h1>join result</h1>
	<cfdump var=#q#>
	<hr>
</cfloop>