MySQL joins

Updated: 19 April 2023

Equivalent statements

LEFT JOIN     LEFT OUTER JOIN
RIGHT JOIN    RIGHT OUTER JOIN
FULL JOIN     FULL OUTER JOIN
INNER JOIN    JOIN