Using Outer Joins
A Brief Overview
An outer
join returns nonmatching rows as well as matching rows.
|
Type of Outer Join
|
Output
|
|---|---|
|
Left
|
Returns all rows from
the left table (first table) and matching rows from the right table
(second table) that are specified in the FROM clause.
 |
|
Right
|
Returns all rows from
the right table (second table) and matching rows from the left table
(first table).
 |
|
Full
|
Returns all matching
and nonmatching rows from all the tables.
|
Outer Join Syntax
|
Syntax, SELECT statement for outer ... |
Get SAS Certified Professional Prep Guide 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.
