comparing two tables?

[Lord Merlin]

How do I compare the contents of two tables, to see what doesn't exist in
the one table?

Something like "select company.name, company_scores.company_name from
company, company_scores where company.name not in
company_scores.company_name" ?

--
Kind Regards
Rudi Ahlers
[phone]

Greater love has no one than this, that he lay down his life for his friends
(John 15:13).

[Bob Barrows [MVP]]

Lord Merlin wrote:

How do I compare the contents of two tables, to see what doesn't
exist in the one table?

Something like "select company.name, company_scores.company_name from
company, company_scores where company.name not in
company_scores.company_name" ?

Please don't multipost. I've already replied to this question over at
..asp.db. If you feel you must direct your question at multiple
newsgroups*, then post one single message to the desired groups by
putting the group names into the To list (aka crosspost)

*.asp.db is the only group you needed to post this to. Your question
concerns asp and database code: absolutely no ambiguity.

Bob

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Binoj Antony]

Try This

<CODE>

SELECT company.name, company_scores.company_name
FROM company
LEFT JOIN company_scores ON (company_scores.company_name = company.name)
WHERE company_scores.company_name IS NULL

OR

SELECT company.name, company_scores.company_name
FROM company
LEFT JOIN company_scores ON (company_scores.company_name = company.name)
WHERE company.name IS NULL

</CODE>