表鏈接
2024-07-21 02:45:10
供稿：網(wǎng)友
---1. 普通的相等連接
select e.last_name, d.department_name
from employees e, departments d
where e.department_id = d.department_id;
---2 左外連接 LEFT OUTER JOIN
select e.last_name,e.department_id,d.department_name
from employees e
left outer join departments d
on (e.department_id = d.department_id);
select e.last_name, d.department_name
from employees e, departments d
where e.department_id = d.department_id(+);
結果為：所有員工及對應部門的記錄，包括沒有對應部門編號department_id的員工記錄。
----3. 右外連接 right outer join
select e.last_name,e.department_id,d.department_name
from employees e
right outer join departments d
on (e.department_id = d.department_id);
select e.last_name, d.department_id,d.department_name
from employees e, departments d
where e.department_id(+) = d.department_id;
結果為：所有員工及對應部門的記錄，包括沒有任何員工的部門記錄。
----4.FULL OUTER JOIN：全外關聯(lián)
select e.last_name, e.department_id, d.department_name
from employees e
full outer join departments d
on (e.department_id = d.department_id);
結果為：所有員工及對應部門的記錄，包括沒有對應部門編號department_id的員工記錄和沒有任何員工的部門記錄。
本文來自CSDN博客，轉載請標明出處：http://blog.csdn.net/Phoenix_99/archive/2009/12/30/5107827.aspx
