Type of Join
|
Output
|
---|---|
Inner
join
|
Only the rows that match
across all table(s)
|
Outer
join
|
Rows that match across
tables (as in the inner join) plus nonmatching rows from one or more
tables
|