The answer depends on the version of SQL you’re using. In some cases, the INNER JOIN syntax results in more efficient processing. The LEFT JOIN: Matching records plus orphans from the left So ...

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): ...