[thelist] simple SQL help please

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Thu Feb 2 09:57:40 CST 2006

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...



 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 


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


Where a.company <> b.company

It's probably something simple...

Rob Smith
rob.smith at lexjet.com
(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. * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list