Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: outer join to 2 tables ??
kiel wrote:
> 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
If you fail to use outer join twice to two different tables, why not just
try to
outer join each table and then UNION the results ? Look stupid but
logically works.
John K. Received on Mon Feb 08 1999 - 10:54:36 CST