Exactly Mark. I was just going to suggest that rather than making CF work on it.
-----Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:20 PM To: CF-Talk Subject: RE: Not in? A simple way of doing this would be: select firstname from tableA where recordid not in (select recordid from TableB) You may want look into a join depending on the use. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:46 AM To: CF-Talk Subject: Not in? 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 KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists