How do I compare 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
+27 (82) 926 1689

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" ?

What database?

--
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"

[Aaron [SQL Server MVP]]

You could use a LEFT JOIN, but you'll need to provide more information.
What database are you using, what version? What are the keys in the tables?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)





"Lord Merlin" <SPAM_lordmerlin@bonzai.org.za_SPAM> wrote in message
news:ccs9ol$ral$1@ctb-nnrp2.saix.net...

> 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" ?

[CST]

Take the table with the most records and do something like this:
select t1.name, t1.company_name
from company t1 left outer join
company_scores t2 on t1.name = t2.company_scores

w/o more info. this is the best I can do for you.

"Lord Merlin" <SPAM_lordmerlin@bonzai.org.za_SPAM> wrote in message news:<ccs9ol$ral$1@ctb-nnrp2.saix.net>...

> 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
> +27 (82) 926 1689
>
> Greater love has no one than this, that he lay down his life for his friends
> (John 15:13).