28.2.5 Joins (cont.)

Remember:
- List appropriate tables in the FROM clause
- Use the TableName.ColumnName syntax
- List all join conditions (TableName1.ColumnName1 = TableName2.ColumnName2) in the WHERE clause
Queries can be complex
SQL doesn't specify how to search
DBMSs are very good at queries