This should be rather simple but for some reason I cannot figure this out. I have two tables in my database. The first is Vendor_Price_List and the other is All_Products. In both tables is a field called dc_custom_upc. I want to find the records within the Vendor_Price_List table that has a value in the dc_custom_upc field that does not exist in the All_Products table.
I have attached my code for review. What is confusing me is that that I change dc_custom_upc to another field, such as name or sku, it returns records. I have tested this with one record in the Vendor_Price_List table with a dc_custom_upc that I know for a fact does not exist in the other table.
WHERE "dc_custom_upc" not in (SELECT "dc_custom_upc" FROM dbo.All_Products);