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

You can write it as is in 9i and above (ANSI join syntax is supported). Received on Mon Oct 23 2006 - 11:04:32 CDT