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

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 ! 





More information about the thelist mailing list