News
There must be some reason he's preferring the left join, though it's not obvious from the example. As far as equivalence, they're not going to have the same effect.
However, this example comes from a real-world case where my client expected me to clean up dirty or missing data. ... When you execute a query using the LEFT JOIN syntax, SQL does two things: ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results