[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