When you execute a query using the LEFT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause. It also returns ...

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 ... as per my understanding of SQL joins): ...