Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Where not exists(ProductID) sounds correct. See this example.
Thank you for confirming.