OUTER JOIN
LEFT JOIN keeps every row of the first table, matched or not; RIGHT JOIN keeps every row of the second; FULL OUTER JOIN keeps both. Rows with no match get NULL, which also lets you find what's missing.
Updated
- Category
- SQL
- Level
- Journeyman
- Tags
- FULL OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, sql, t-sql