help creating a ms query!!! 2

[domi1]

I was wondering if anyone can help me create a sql query

I have 2 databases lets say A and B, and both contain a contacts table and ARE supposed to hold the same records but after running a query i found that Im missing about 400 records on database B

how can I find wich contacts are missing from database A

thanks!!

 

[DotNetGnat]

Does this work?

SELECT contactID,contact Name from
B.dbo.Contacts WHERE contactID NOT IN (
Select contactID from A.dbo.Contacts)

-DNG

 

[amrita418]

Try this:

SELECT       a.contactID, b.contactID 
from         a.dbo.Contacts a
             left outer join b.dbo.Contacts b
             on (a.ContactID = b.ContactID)
where        b.contactID IS NULL

Regards,
AA

 

[amrita418]

When I read your requirement again, I see that you have contradicting statements:

> i found that Im missing about 400 records on database B

which is what the code does.

But if next statement is true

> how can I find wich contacts are missing from database A

then you need left outer join on B instead.

 

[domi1]

thank you very much ! amrita418
that was exactly the query I was looking for I tested it and its working

the last request I have is is it possible to export the results of the query to dbf file or mdb file?

thanks!

 

[jbenson001]

You can use DTS to export.