Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: need help (Not anymore) with this SQL Query
I found why it didn't work...
the problem is not that I link to more than one table, it's the way I link the tables :
Select *
From A, B, C
where A.Size_Code || A.Sequence = B.Size_Code || B.Sequence (+)
And A.Dimension || A.Sequence = C.Dimension || C.Sequence (+)
it don't seem to like concatenations in it's join...
Patrick Joyal wrote in message <38bfe46b_at_news>...
>Hi,
>
>I have a large SQL Query i'm trying rewrite. Basically, what I need is this
>:
>
>I have 3 tables, A, B and C
>
>A can be related to B with the common field Size_Code
>A can be related to C with the common field Dimension
>
>at first my query looked like this
>
>
>Select *
> From A, B, C
>where A.Size_Code = B.Size_Code (+)
> And A.Dimension = C.Dimension (+)
>
>but the I have this message : "ORA-01417: a table may be outer joined to at
>most one other table"
>
>so I rewrote it like this :
>
>Select * from
> (
> Select *
> from A, B
> Where A.Size_Code = B.Size_Code (+)
> ) AB, C
> Where AB.Dimension = C.Dimension (+)
>
>but it gives me the exact same message
>
>
>If it can give you any clue, the original query was made for Access and
>looked like this (and was working) :
>
>Select *
> from (( A Left Join B ) on (A.Size_Code = B.Size_Code)) Left Join C
on
>(A.Dimension = C.Dimension)
>
>
>
>So, if anyone have any idea, please let me know.
>
>thanks
>
>Patrick
>
>
>
>
>
Received on Fri Mar 03 2000 - 00:00:00 CST