Oracle to DB2 conversion...

[filex]

Hello, can you please tell me how would an Oracle select statement below:
"select OUTER.FEILD1 X0 FROM XX_PEVP "OUTER", XX_PEVP "INNER" WHERE OUTER.FIELD2 = INNER.FIELD3 (+) AND OUTER.FIELD4 = 'XXXXXXX'"

will look on DB2, I don't know what "(+)" to submit with...Thank you.

 

[Crox]

Hi,

I don't know what the (+) part of the source means...

Can you explain that?

Regards,

Crox

 

[alphonsus]

Try this

select
a.col_x
from
outtable a
left outer join intable b on
a.col_y = b.col_y
where
a.col_n = 'xxxx'

Regards,

Alphonsus.