1/5
Final
Tables are related based on common ___.
Keys (similar fields)
How do we organize data in a meaningful way from different tables
join/link the related tables
Inner Joins
Record must have a match in the corresponding table to be included in the output
Inner Join EXAMPLE
SELECT <select_list>
FROM TableA A
INNER JOIN TableB B
ON A.Key = B.Key
Outer Join [ Left Join ]
Keeps all records from the “Left” table regardless of whether the record has a match in the other table
Outer Join EXAMPLE
SELECT <select_list>
FROM TableA A
LEFT JOIN TableB B
ON A.Key = B.Key