Please enable JavaScript.

Coggle requires JavaScript to display documents.

Ch. 9 - Data Integration (Joins (Combines two datasets with shared…

- - - - Output: header row and three data rows; NULLS indicate nothing purchased
      - When goal is to collect as much info as possible (referential integrity - will not accept something unless ...)
    - - Output: header row, three data rows; NULLs indicate we do not know belonging info
    - - Output: header row and four data rows; combines both tables to understand NULLs
      - Left table + Right table = Output
      - To connect different lists if rows and a shared identifier overlap to allow for integration