[thelist] simple SQL help please

Jay Blanchard jay.blanchard at THERMON.com
Thu Feb 2 09:49:24 CST 2006


[snip]
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
[/snip]

SELECT A.foo 
FROM A LEFT OUTER JOIN B
ON (A.something = B.something)
WHERE B.something IS NULL



More information about the thelist mailing list