From: "Patrick Joyal" <please.reply@to.the.newsgroup>
Subject: Re: need help (Not anymore) with this SQL Query
Date: 2000/03/03
Message-ID: <38bfe5b4@news>#1/1
References: <38bfe46b@news>
X-Original-NNTP-Posting-Host: 204.19.207.22
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: MetroNet Communications Group Inc.
NNTP-Posting-Date: Fri, 03 Mar 2000 09:12:03 MDT
Newsgroups: comp.databases.oracle.misc


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@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
>
>
>
>
>