Joins

• A query that involves multiple tables is a join
• When using a join, do these things
  • List all tables that are involved in the query in the FROM clause
  • Use the TableName.ColumnName syntax to refer to column names
  • List all join conditions in the WHERE clause
    (TableName1.ColumnName1 = TableName2.ColumnName2)