emulate Outer join

Hi all,

How to emulate an outer join without using the (+) operator?

select *
from tab1 a, tab2 b
where b.id(+) = a.id

select *
from tab1 a, tab2 b
where ???...nvl(decode(....????

Thanks Paolo Received on Mon Apr 02 2001 - 10:25:11 CDT