Cara Menampilkan Data Dari Beberapa Tabel Dengan Beberapa Metode (ORACLE)

Penggunaan Klausa WHERE

SELECT Employees.department_id, Employees.last_name,
Departments.department_name
FROM Employees, Departments
WHERE Employees.Department_id=Departments.Department_id

Penggunaan JOIN ON

SELECT E.department_id, E.last_name, D.department_name
FROM Employees E JOIN Departments D
ON E.Department_id=D.Department_id

Penggunaan NATURAL JOIN

SELECT last_name, department_name
FROM employees
NATURAL JOIN departments

Penggunaan OUTER JOIN

SELECT E.department_id, E.last_name, D. department_id, D.department_name
FROM Employees E, Departments D
WHERE E.Department_id(+)=D.Department_id

Penggabungan tabel itu sendiri (Joining a Table to Itself)

SELECT Karyawan.last_name || ' bawahan dari ' || Manager.last_name
FROM Employees Karyawan, Employees Manager
WHERE Karyawan.manager_id= Manager.employee_id