Databases Reference
In-Depth Information
205 Higgins, Shelley Accounting
206 Gietz, William Accounting
106 rows selected.
The
JOIN ... ON
clause is the only SQL:1999 equijoin clause that supports joining
columns with different names.
Join Using
with Three Tables
Later in the afternoon, one more request comes in from King: He wants to see a list
of employees similar to the query Janice just ran, but instead of departments, he
wants to see the city where the employee is working, and only employees in depart-
ment 40, Human Resources. Looking at the EMPLOYEES table, the DEPARTMENTS
table, and the LOCATIONS table, you can see that there is no direct route from
EMPLOYEES to LOCATIONS. Janice must “go through” the DEPARTMENTS table to
fulfill King's request. She must take the following route to get from EMPLOYEES
to LOCATIONS:
EMPLOYEES
DEPARTMENTS
LOCATIONS
