Re: Outer join problem

gabriel.gibaut_at_gmail.com wrote:
> I suspect this isnīt the right newsgroup (but itīs the best match i
> could find) if so, please point me to the right one. Thanks.
>
> Well, my problem is related to the "a table may be outer joined to at
> most one other table" problem . I searched for solutions but couldnīt
> find any idea that i could use to solve my situacion. The sentence is
> the following:
>
> SELECT * FROM A, C, B, D
> WHERE
> A.A = B.A AND
> A.C = C.C AND
> B.X = D.X (+) AND
> C.C = D.C (+)
>
> Thanks in advance
>
> Gabriel

Two possible solutions.

1. Use ANSI syntax
2. Create an in-line view with an outer join then outer join the in-line view to the balance of the query.

Either will work.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)