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

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 23 Oct 2006 13:33:28 -0700
Message-ID: <453d2718$1@news.victoria.tc.ca>

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)
: --------------------------

Oracle now has RIGHT JOIN etc syntax, so have you tried the query as-is? it may just run ok already. Received on Mon Oct 23 2006 - 15:33:28 CDT

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