In this example, the LEFT JOIN answers the following business question: ... most implementations of SQL support the INNER JOIN, LEFT JOIN, and RIGHT JOIN constructs.

An inner join is the most common and basic type of SQL join. It returns only the rows that match on a specified condition in both tables. For example, if you want to join a table of customers with ...

This repository provides examples of LEFT JOIN and INNER JOIN in MySQL, demonstrating how to combine rows from two or more tables based on a related column. INNER JOIN retrieves records that have ...

Inner join produces a dataset that includes rows from the left table, matching rows from the right table. The syntax for the inner join is as follows: SELECT column_list FROM left_table INNER JOIN ...

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.