Pertemuan 4

SELECT employee_id, employees.department_id, departments.department_name

FROM employees, departments

WHERE employees.department_id = departments.department_id

SELECT employees.employee_id, employees.last_name, employees.department_id, departments.department_id, departments.location_id

          FROM employees, departments, locations

WHERE employees.department_id = departments.department_id

AND departments.location_id = locations.location_id;

SELECT E.first_name, E.salary, J.job_title

         FROM employees E, jobs J

WHERE E.salary BETWEEN J.MIN_salary AND J.MAX_salary;

SELECT E.last_name, E.department_id, D.department_name

FROM employees E, departments D

WHERE E.department_id(+) = D.department_id;

SELECT worker.last_name ||' Work For '|| manager.last_name

          FROM employees worker, employees manager

WHERE worker.manager_id = manager.employee_id;