Help with a query

[coolkake]

Hi All

I've got a database that gets info imported into it from another one and after things where working well for about a year I now have a problem.

I have a ORG table and a PRODUCTS table. I just found out that one ORG_ID in the PRODUCTS table doesn't exist in the ORG table Now I want to know if I have any other ORG_ID in the PRODUCTS table that don't exist in the ORG table but I can't seem to make a query that works.

Any ideas for me to try?

 

[coolkake]

Solved it myself, used Find Unmatched Query Wizard. Didn't even think to look to see if there was a wizard!

Cheers

 

[Transcend]

Well done coolcake

Trancend