In what scenario does an INNER JOIN produce the same result as a LEFT JOIN?

Question

SQL Data Analyst — Medium

In what scenario does an INNER JOIN produce the same result as a LEFT JOIN?

Accepted Answer

An INNER JOIN produces the same result as a LEFT JOIN when every row in the left table has at least one matching row in the right table. This means that all records from the left table are included, even if they don't have a match in the right table.