<!--- Query for TransID values. --->
<cfquery name="qStrict" 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 IN ( 1,4 )
	GROUP BY
		d.trans_id
	;
</cfquery>
 
 
<!--- Output out results. --->
TransID: #ValueList( qStrict.trans_id, ', ' )#