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