ORACLERetrievingdatafrom4tables（ORACLE从4个表中检索数据）

例子：假设有两个表（employees和departments），每个部门有一个经理，然后有一个job_history表，其中记录了先前由员工担任的职位。

SELECT e.employee_id, e.last_name, e.first_name, d.department_name, m.last_name manager_lastname, m.first_name manager_firstname, jh.start_date, jh.end_date, j.job_title FROM employees e, departments d, employees m, job_history jh, jobs j WHERE e.department_id = d.department_id AND d.manager_id = m.employee_id AND e.employee_id = jh.employee_id(+) AND jh.job_id = j.job_id(+) ORDER BY e.employee_id;