SELECT Query Quest... JOINING table, finding missing records

microsoft.public.sqlserver.programming

2 Jan 2007 8:30 PM

Ryan McAtee

I have a table of documents, say dbo.docs

acct, docid, etc.
1, 0001, etc.
2, 0002, etc.
3, 0006, etc.
4, 0008, etc.

And a name table, say dbo.name

acct, name
1, Joe
2, Jerry
4, Jack

I want to run a query that finds records in dbo.docs that do not have an
associated record in the dbo.name table. In this instance, it would be:

3, 0006, etc.

We have a problem where some reference data was deleted in eMC's
ApplicationXtender and I want to try to find the account numbers we're
missing names on.

Thanks!
Ryan