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 |