Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch. 9 Data Integration (Joins (outer join (left outer join ("This…
Ch. 9 Data Integration
Joins
-
-
info on left, behavior on right
Inner Join
"each row in the left table is combined horizontally (see Figure 9.2) with any row in the right table that has the same identity value" (77)
-
outer join
left outer join
"This join produces the same result as an inner join but also adds any rows from the left table that do not have corresponding rows in the right table." (77)
-
Right outer join
"This join produces the same result as an inner join, but also adds any rows from the right table that donot have corresponding rows in the left table." (78)
full outer join
"This join produces the same result as an inner join + a left outer join + a right outer join." (78)
-
Union
-
-
-
"Generally, we perform unions when we have datasets that contain unique sets of cases sharing the same or very similar columns." (84)