
Questions
1. Could the join condition employee.room_no = telephone.room_no have been
substituted for one of the join conditions in Example 2? (2 min)
2. Write a SELECT statement that returns the names of employees supervised by
employee(s) called 'Smith'. (2 min)
0RUH-2,1V
There are several other ways of specifying a join, as shown below.
Example 1
SELECT emp_no, emp_name, telephone.room_no, extension
FROM employee JOIN telephone
ON employee.room_no = telephone.room_no
The JOIN itself includes employee.room_no and telephone.room_no columns (which
will have identical values). In this example, the SELECT clause eliminates the
employee.room_no column. ...