previous |
start |
next
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)
previous |
start |
next