A join method that includes data even when it doesn't match.
An umbrella term for a LEFT, RIGHT, or FULL join, all of which fill the non-matching side with NULL. In most SQL dialects, the OUTER keyword itself is optional -- writing just LEFT JOIN or RIGHT JOIN already means the same thing as LEFT OUTER JOIN or RIGHT OUTER JOIN.
© 2026 ITBGM