Oracle/SQL Fundamentals I
8일차 # 5-13: Join On (condition)
Bohemian life
2012. 4. 13. 17:12
select e.employee_id, e.last_name, e.department_id,
d.department_name, d.location_id
from employees e
join departments d
on (e.department_id = d.department_id);
↓ ↓ ↓
<Join Using>
select e.employee_id, e.last_name, department_id,
d.department_name, d.location_id
from employees e
join departments d
using (department_id);
↓ ↓ ↓
<Oracle Syntax>
select e.employee_id, e.last_name, e.department_id,
d.department_name, d.location_id
from employees e, departments d
where e.department_id = d.department_id;