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)
 |
|
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.
