SQL Joins

Learning Objectives

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

How to Complete this Lesson

Complete the following learning activities: (2.75–3.5 hours total)

1. Complete Execution Hiatuses from Select Star SQL (45–60 minutes)
2. Attend the class meeting (60 minutes)
3. Complete the practice queries
4. Work on the SQL programming exercise (PEX) (60–90 minutes)
   • Complete queries 16–20 (LargeCo database)

Resources

• Questions for the Structured Query Language (SQL) (45–90 minutes)

---

« SQL Aggregates

SQL Subqueries »