Alright, I got the (‘) removed from all of the files. So, I have the same fields in both tables now. In Table 1 there are 46 columns, and in Table 2 there are 4 columns.
· Handle (Product name) (Table 1 & Table 2)
· Vendor (Table 1 & Table 2)
· Variant SKU (Table 1 & Table 2)
· Variant Barcode (Table 1 & Table 2)
·
Table 1 has 867 records (see screenshot)
Table 2 has 552 records (see screenshot)
However, when I use the following statement, I got I get 17172 results which I have no idea how that is possible.
SELECT TABLE1.`handle`, TABLE1.`Variant SKU`, TABLE1.`Variant Barcode`, TABLE2.`Variant SKU`, `TABLE2`.`Variant Barcode` FROM TABLE1 inner JOIN TABLE2 on TABLE1.`Variant SKU` = TABLE2.`Variant SKU` and TABLE1.`Variant Barcode` <> TABLE2.`Variant Barcode`
There are no unique fields.
Why am I getting this many results?
Then, when I join and leave out the barcodes, I get closer to what I am looking for in screenshot Join 2 (not allowed to upload). But again, I get FAR more results than I should!
I am wanting to see where the Variant SKU matches and the Barcode doesn’t. Also, where the SKU doesn’t and the barcodes do. They don’t have to be in the same query, but it would be nice if they do.