Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 89

Figure 2-23
Types of JOINS
(a) The STUDENT and LOCKER Tables Aligned to Show Row Relationships
Only the rows where
LockerFK=LockerPK
are shown—Note that
some StudentPK and
some LockerPK
values are not in the
results
(b) INNER JOIN of the STUDENT and LOCKER Tables
All rows from STUDENT
are shown, even where
there is no matching
LockerFK=LockerPK
value
(c) LEFT OUTER JOIN of the STUDENT and LOCKER Tables
All rows from
LOCKER are shown,
even where there is no
matching
LockerFK=LockerPK
value
(d) RIGHT OUTER JOIN of the STUDENT and LOCKER Tables