> I have 2 queries one that contains the enitre recordset of the table and > 1 that contains my flagged results.
> What I need to do is find a way to display all of the records that > aren't part of query #2's recordset. > Please help SELECT * FROM mytable WHERE myprimarykey NOT IN (#valuelist(myquery.mycolumn)#) assuming your pimary key is a number ... if not, use #quotedvaluelist(myquery.mycolumn)# hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
