Using Outer Joins

Introducing Types of Outer Joins

An outer join combines and displays all rows that match across tables, based on the specified matching criteria (also known as join conditions), plus some or all of the rows that do not match. You can think of an outer join as an augmentation of an inner join: an outer join returns all rows generated by an inner join, plus additional (nonmatching) rows.
Type of Outer Join
Output
Left
All matching rows plus nonmatching rows from the first table specified in the FROM clause (the left table)
Venn Diagram, Left Outer Join
Right
All matching rows plus nonmatching rows from the second table specified in the FROM ...

Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.