Re: Oracle and JOIN

It does not support that particular syntax but you can achieve outer joins in oracle by using the "(+)" operator example:

select t1.foo_name
  from foo t1,

       bar t2
 where t1.foo_id = t2.foo_id(+)

JJ wrote:

> Hi,

> Does Oracle 8i supports LEFT OUTER JOIN... statements?

> --
> Best regards

> Joacim Jarkeborn

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Mon Aug 27 2001 - 11:51:17 CDT