guotch的专栏

原创 ORACLE LEFT JOIN时如果被匹配的两个字段都为NULL，被视作不相等

select a1,b1,a2,b2,a1.c from (select 1 as a1,2 as b1 ,null as c )a1 left JOIN (select 3 as a2,2 as b2 ,null as c )a2 on a1.c= a2.c 该查询的结果是： a b a2 b2 c 1 2 \N \N \N...