<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Ask Ben: Querying Groups With Conditional Elements Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1121.view Date Posted: Jan 14, 2008 at 7:00 AM ---- --------------------------------------------------------------------------------------- ---> #PreserveSingleQuotes( strBuildSQL )# SELECT d.trans_id FROM @data d WHERE d.tag_id IN ( 1,4 ) GROUP BY d.trans_id ; TransID: #ValueList( qStrict.trans_id, ', ' )#