重庆思庄Oracle、Redhat认证学习论坛

标题: 全外连接的另一种写法 [打印本页]

---

作者: 郑全    时间: 2012-11-27 15:27
标题: 全外连接的另一种写法
select e.employee_id,d.department_NAME
from employees e,departments d
where e.department_ID=d.department_ID(+)
union
select e.employee_id,d.department_NAME
from employees e,departments d
where e.department_ID(+) =d.department_ID

---

欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2