Generate_Inner_Join

Inner_Join.sql

-- Inner Join with the ON Clause
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
  FROM employees e JOIN departments d
    ON (e.department_id = d.department_id);

-- Inner Join with the Equal (=) Operator
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
  FROM employees e, departments d
 WHERE e.department_id = d.department_id;