Oracle串連查詢

標籤：between   匹配   交叉串連   串連查詢   acl   查詢   select   out   串連   

--交叉串連（會產生笛卡爾積）
select * from emp cross join dept;
--自然串連(可自動匹配關聯欄位並消除笛卡爾積)
select * from emp natural join dept;
--JOIN...USING,USING子句後跟關聯的欄位
select * from emp e join dept using(deptno);
--JOIN...ON,ON子句後面跟關聯的條件
select * from emp e join salgrade s on (e.sal between s.losal and s.hisal);
--左外串連LEFT OUTER JOIN...ON
select * from emp e left outer join dept d on (e.deptno = d.deptno);
--左外串連也可以寫成這樣：
select * from emp e ,dept d where e.deptno = d.deptno(+);
--右外串連RIGHT OUTER JOIN...ON
select * from emp e right outer join dept d on (e.deptno = d.deptno);
--右外串連也可以寫成這樣：
select * from emp e ,dept d where e.deptno(+) = d.deptno;
--全外串連FULL OUTER JOIN
select * from emp e full outer join dept d on (e.deptno = d.deptno);

Oracle串連查詢