Please enable JavaScript.

Coggle requires JavaScript to display documents.

Ch. 9 Data Integration (JOINS (Outer Joins (Left Outer Join (Same as inner…

- - - - very complicated
- - - - A through C in common, makes E
- - - - Same as inner join, except adds rows for non corresponding rows from left table
    - - Same as inner join, except adds rows for non corresponding rows from right table
    - - Joins all of the above. Rows created for no orders and for orders with no customers