Outer Joins
-
Left
outer join of S and R:
-
take
inner join of S and R (with whatever qualification)
-
add
tuples of S that are not matched in inner join, filling in attributes coming
from R with "null"
-
Right
outer join:
-
as
for left, but fill in tuple of R
-
Full
outer join: