php on ORACLE.

[sfc12345]

Does anyone know how to do outer join for oracle?

I have a query in my php code as follow:

select table1.field1, table1.type, table2.type
from table1, table2
where table1.type = table2.type (+)

NOTE: table1 and table2 containe the same field name "type".

Please help.

[bastien]

select table1.field1, table1.type, table2.type
from table1, table2
where table1.type = table2.type
union
select field1, type from table1 where type not in(select type from table2)

hth

Bastien

[sfc12345]

Thanks for help.