Chapter 2 C H A P T E R T W O Joins, Unions, and Views Hacks 7­14 You can use a join to associate the rows of one table with the rows of another. Often you do this to follow a foreign key reference. For example, consider an employee table that contains a column with the id of the depart- ment for each employee. If you need to see the name of the department for each employee, you can use a JOIN , as in: SELECT employee.name, department.name