SELECT employee_id, city, department_name

  FROM   employees e 

  JOIN   departments d

  ON     d.department_id = e.department_id 

  JOIN   locations l

  ON     d.location_id = l.location_id;


      ↓ ↓


<Oracle Syntax>

  SELECT employee_id, city, department_name

  FROM   employees e, departments d, locations l

  WHERE  d.department_id = e.department_id 

  AND    d.location_id = l.location_id;



'Oracle > SQL Fundamentals I' 카테고리의 다른 글

8일차 # 5-23: LEFT OUTER JOIN  (0) 2012.04.13
8일차 # 5-19: Non-Equijoin  (0) 2012.04.13
8일차 # 5-17: 조건 추가  (0) 2012.04.13
8일차 # 5-15: Self-Join  (0) 2012.04.13
8일차 # 5-13: Join On (condition)  (0) 2012.04.13

+ Recent posts