SQL JOINs make it easy to find and fix missing ... even if there aren’t any matching values in the table on the right. In this example, the LEFT JOIN answers the following business question ...

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 ... (example 1 and 3 achieve the same end result on tableA as per my understanding ...