What about SELECT a.company FROM a WHERE a.company NOT IN(SELECT b.company FROM b) Of course this assumes you're using something more reliable than company names or other text fields for comparison... Cheers, Peter ---------------------------------------- From: "Rob Smith" <rob.smith at lexjet.com> Sent: Thursday, February 02, 2006 8:46 AM To: thelist at lists.evolt.org Subject: [thelist] simple SQL help please Hi, List A contains all leads acquired from a recent trade show. List B contains our entire contact database. Find all entries in List A, not in List B, without returning all contents of List B. I don't want: Select A.Company FROM A, B Where a.company <> b.company It's probably something simple... Rob Smith LexJet rob.smith at lexjet.com http://www.lexjet.com (800)453-9538 (941)330-1210 Int'l (941)330-1220 Fax 1680 Fruitville Road, 3rd Floor Sarasota, FL 34236 Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org) -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !