LEFT/RIGHT OUTER JOIN

← Back to Joins

LEFT JOIN returns all rows from the left table plus matching rows from the right table. RIGHT JOIN does the inverse. Non-matching rows are filled with NULLs.

relational-databases sql joins