Oracle & DB2 - Outer Joins

I'm trying to port application to work with both Oracle and db2. How do I achieve this Oracle query in db2

Q1. Select a.key, b.desc1, c.desc1

       from a,b,c
      where a.key = 10
        and a.code1 = b.code(+)
        and a.code2 = c.code(+)

Q2. Select key from a where a.key(+) = 10

Thanks
Murali

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 27 1999 - 20:03:55 CST