[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