Chapter 9

SQL Part 3: Joins

Learning Objectives

Upon completing all the content in this chapter, you should be able to do the following:

  1. Understand what a join is.
  2. Write queries that use inner, full, left, and right joins.
  3. Explain the differences between the types of joins listed above.
  4. Use the HAVING clause with joins to filter result sets.

Key Terminology

Here is a list of key terms for this chapter broken down by the page the term first appears on. Make note of each term and its definition.

What is a Join?

  1. join

Inner Joins

  1. inner join

Left and Right Joins

  1. left outer join
  2. right outer join

Full Outer Joins

  1. full outer join

Content Links