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

'Thanks in advance' for what? You've provided no table structure, no Oracle release, no error message text or error number. Also a 'select *' from more than one table using a query structured as you've posted will provide more than enough errors stating 'column ambiguously defined'.

When you can clarify your question and provide the required information on Oracle release, table structure, etc., possibly a solution to your 'problem' can be presented. We can't, and won't try to, read minds.

David Fitzjarrell Received on Mon Aug 29 2005 - 11:24:19 CDT