A JOIN that keeps all rows from both tables, including the parts that don't match.
A join that keeps all rows from both tables regardless of whether they match, filling in NULL on the side that has no match. MySQL has long lacked direct support for FULL OUTER JOIN, and the common workaround is to reproduce the same result by combining a LEFT JOIN and a RIGHT JOIN with UNION.
© 2026 ITBGM