Looking for help with a query

[Jay]

I have 2 tables related by an id

1)
id bigint(20) unsigned
url text

2)
site bigint(20) unsigned
word text

How can I find all of the records in table 2 where there is no record in
table one with an id=site ? I have orphaned words in the second table I
actually want to delete.

TIA,
Jay

[Bill Karwin]

Jay wrote:

How can I find all of the records in table 2 where there is no record in
table one with an id=site ? I have orphaned words in the second table I
actually want to delete.

select site, word
from table2 left outer join table1 on table2.site = table1.id
where table1.id is null;

Bill K.

[news]

"Bill Karwin" <bi**@karwin.com> wrote in message
news:cg*********@enews1.newsguy.com...

select site, word
from table2 left outer join table1 on table2.site = table1.id
where table1.id is null;

Bill K.

Many thanks,
Jay