<!--- Query for TransID values. --->
<cfquery name="qRelaxed" datasource="#REQUEST.DSN.Source#">
	<!--- Build SQL table and populate. --->
	#PreserveSingleQuotes( strBuildSQL )#
 
 
	<!--- Get the appropriate trans IDs. --->
	SELECT
		d.trans_id
	FROM
		@data d
	WHERE
		d.tag_id = 1
	OR
		d.tag_id = 4
	OR
		d.tag_id != 2
	GROUP BY
		d.trans_id
	;
</cfquery>
 
 
<!--- Output out results. --->
TransID: #ValueList( qRelaxed.trans_id, ', ' )#