Joining Tables

Lecture

• What is a table join
• Creating table joins
• The importance of the join condition
• Cartesian product
• Qualifying column names
• Aliasing tables
• The old Join syntax
• The new standard Join syntax
• The Inner Join
• The Outer Join
• The Self Join
• Set operators, UNION, INTERSECT, MINUS
• Combining Join with UNION
• Performance considerations