I think there is better performance, and only one db call, by doing a left outer join on the table you want all records from and adding "where table2column is not null".
That is, of course, unless they are the same table, but you could self-join the table with the same technique... Why two recordsets instead of two tables? >>-----Original Message----- >>From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, September 18, 2002 12: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] >> >> >> >> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
