SQL Joins

Preparation

Fundamentals of Database Management Systems

• Chapter 4: Relational Data Retrieval: SQL

Learning Objectives

• Compare and contrast the following types of joins:
  • cross
  • inner
  • left / right
  • outer
• Use the SQL’s JOIN clause to perform the aforementioned types of joins

Practice

Complete the lab as time permits in class (or outside of class)