Not Loading Certain Rows

[Anonymous]

I have tow tables A and B, A is master table, there are few rows in table B. They both have Product ID field. I do not want to load Product IDs from A that are present in B.

Should I use

Where not exists(ProductID) ?

or any other suggestions.

[Gysbert_Wassenaar]

Where not exists(ProductID) sounds correct. See this example.

[Anonymous]

Thank you for confirming.