October 2019
Intermediate to advanced
430 pages
19h 4m
English
|
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.
|
|
Syntax, SELECT statement for outer ... |