表連接注意left join on與where的區別:
select * from dept;
select * from emp;
select * from emp a right outer join dept b on a.deptno=b.deptno where a.empno is null;
select b.deptno,a.* from emp a right join dept b on a.deptno=b.deptno and a.empno is null;
這裡注意oralce執行順序:
第一個語句(where):
第二個語句: