outer join to 2 tables ??

Hi,
this probably demonstrates my hopeless lack of knowledge of outer joins, but so be it:

I have a select like this

select data.a, data.b, data.c, translation.trans   from data, translation, parent
 where data.parent_id = parent.id
   and parent.lang = translation.lang(+)    and data.c = translation.org(+)

That fails since I can't outer join translation to more than one table. What I'd like to do, is get the data.(a,b,c) returned even, if I don't have a translation for data.c in translation. If I take away the (+) where I join parent and translation, the query will just not return records for which there is no translation of data.c in translation.

Hope that makes sense, and thanks in advance for any clues on how to work around this.

Christian Received on Fri Feb 05 1999 - 11:55:49 CST