outer join.txt

来自「oracle问题集」· 文本 代码 · 共 9 行

-------------------------------------
select * from a, b 
where a.c = b.c + 
and b.c is null
-------------------------------------
the above outer join returns same result as

select * from a where a.c not in (select c from b)