10.1 Learning Objectives

  • To create SQL queries that retrieve data from multiple tables using the SQL join and JOIN ON operations

  • To create SQL queries that retrieve data from multiple tables using the SQL OUTER JOIN operation

  • To create SQL queries that retrieve data from multiple tables using SQL set operators UNION, INTERSECT, and EXCEPT