outer join.txt

oracle问题集

-------------------------------------
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)