OUTER JOIN on more than 2 tables!

[rotem_fo]

Hi,
Oracle says you have to join b and c in a view first.
Try this:

SELECT * from a,b,c
WHERE a.id = b.id AND
a.id = c.id (+)
and b.id in (select b.id from b,c where b.id = c.id (+));

regards,
R.