Thanks! I'm having a rough day... I thought it was not in but I figured I would ask....
KP -----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] ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
