Joining More than Two Tables

Join_More_than_Two_Tables.sql

-- Joining more than two tables with JOIN and ON keywords
SELECT e.last_name, d.department_name, l.city
  FROM employees e JOIN departments d
    ON (e.department_id = d.department_id)
  JOIN locations l
    ON (d.location_id = l.location_id);

-- Joining more than two tables with equal (=) operator
SELECT e.last_name, d.department_name, l.city
  FROM employees e, departments d, locations l
 WHERE e.department_id = d.department_id
   AND d.location_id = l.location_id;