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.
Venn Diagram, Left Outer Join
Right
Returns all rows from the right table (second table) and matching rows from the left table (first table).
Venn Diagram, Right Outer Join
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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.