<--- --------------------------------------------------------------------------------------- ---- 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 = 1 OR d.tag_id = 4 OR d.tag_id != 2 GROUP BY d.trans_id ; TransID: #ValueList( qRelaxed.trans_id, ', ' )#