3 docs tagged with "outer join"

Learn about SQL FULL OUTER JOIN, how it works, syntax, examples, and when to use it for including all records from both tables.

Learn about SQL LEFT JOIN (LEFT OUTER JOIN), how it works, syntax, examples, and when to use it for including all records from the left table.

Learn about SQL RIGHT JOIN (RIGHT OUTER JOIN), how it works, syntax, examples, and when to use it for including all records from the right table.