I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...

I've got a little problem. I need to join two tables both have the field "Product_ID" but the contents of the columns differ slightly. For example: As you can see, in the second table the product ID ...