|< < 32 > >|

Outer joins

Three kinds:

• left join: Keep all rows of the left table, fill in NULLs on the right.

• right join: Keep all rows of the right table, fill in NULLs on the left.

• full join: Keep all rows of both tables, fill in NULLs where needed (left or right).

|< < 32 > >|