Select From Two Tables

[JSOasis]

If a row exists in one table I want to exclude it from query on another table. For example if ID 32 exists in table A I do not want it to show in a query on table B with the same ID. Does any one know hoe to do this?

 

[SQLBill]

What links the two tables?

All you need to do is something like:

SELECT columns
FROM tableb
WHERE id NOT IN (SELECT ID FROM tablea)

-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

Ignore the question. I was going to give another answer using joined tables and realized that wasn't needed, but I forgot to remove the question.

-SQLBill

Posting advice: FAQ481-4875

 

[JSOasis]

Thank you!!!! This worked miracles.