Re: Access Right/Left Joins to Oracle (+) joins - Theorectical Question

mgillesp_at_uoguelph.ca wrote:
> Hey Everyone,
>
> Im just checking my theories on this situation but if you have a
> FROM clause in an Access Table that contains...
>
> -------------------------- (Access)
> FROM
> ((Table1 RIGHT JOIN Table2
> ON Table1.Column1 = Table2.Column1)
> LEFT JOIN Table3
> ON Table2.Column2 = Table3.Column1)
> --------------------------
>
> .... you would need to make the first right join into a sub-query in
> Oracle
>
> -------------------------- (Oracle)
> FROM
> Query1
> Table3
> WHERE
> Query1.Column1(+) = Table3.Column2
> --------------------------
>
> ..... and you could not just make two separate joins like this
>
> -------------------------- (Oracle)
> WHERE
> Table2.Column1 = Table1.Column1(+) AND
> Table3.Column2 (+) = Table2.Column1;
> --------------------------
>
>
> Any kind of input would be a great assistance.
>
> Thanks,
>
> Mitch Gillespie

Maybe I am reading the join contruction wrong:

Full Oracle syntax:
WHERE
  TABLE2.COLUMN1 = TABLE1.COLUMN1(+)
  AND TABLE2.COLUMN2 = TABLE3.COLUMN1(+) You will note that the column names in the second half of the WHERE clause differ from what you specified above.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Oct 23 2006 - 13:24:56 CDT