分步骤的3表外连接：查询所有员工的工作城市

botang

1. select  employee_id, city , department_name from
   
2. ( SELECT employee_id, department_name ,d.location_id from  employees e , departments d
   
3. where  d.department_id   (+)  = e.department_id   )   a ,  locations l
   
4. where a.location_id = l.location_id (+) ;

复制代码

1. SELECT employee_id, city, department_name
   
2. FROM   employees e,   departments d, locations l
   
3. where  d.department_id   (+)  = e.department_id  and    d.location_id = l.location_id (+);

复制代码