A JOIN based on the right table that fills unmatched rows with NULL.
A join that keeps every row from the right table, filling in NULL when there's no matching row in the left table. Because swapping the table order turns it into an equivalent LEFT JOIN, many style guides recommend avoiding RIGHT JOIN altogether and always rewriting it as a LEFT JOIN for consistency.
© 2026 ITBGM