环境搭建:
create table test1 as select * from v$process;
create table test2 as select * from v$session;
场景1:
select test1.* from
test1 left outer join test2 on test1.addr=test2.paddr;
返回记录数:18
场景2:
select test1.* from
test1 left outer join test2 on test1.addr=test2.paddr and test1.spid<>1;
返回记录数:18
场景3:
select test1.* from
test1 left outer join test2 on test1.addr=test2.paddr where test1.spid<>1;
返回记录数:17
结论:
跟在on后面的过滤条件是无效的!要跟where关键字才变得有效!