[thelist] simple SQL help please
Rob Smith
rob.smith at lexjet.com
Thu Feb 2 09:39:09 CST 2006
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)
More information about the thelist
mailing list