[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