Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: JOIN Statements
The RIGHT JOIN and LEFT JOIN syntax is (unfornately) NOT supported in ORACLE.
Gary Bailey
In article <oo2m2.27548$m7.4066_at_newsr2.twcny.rr.com>,
"Michael Tutty" <mtutty_at_rochester.rr.com> wrote:
> I'm porting a prototyped Access database (back end for ASP) to Oracle8. I've
> written about 30 queries in Access, most of which use the PARAMETER clause.
> I have two questions:
>
> 1. Is there any way to migrate these queries to Oracle (I'm using ADO for
> data access, which supports parameters transparently to the driver)?
>
> 2. How do I convince Oracle to do a RIGHT JOIN or LEFT JOIN operation? I've
> seen the outer join (+) symbol, but that's not going to cut it.
>
> Thanks in advance,
> M.
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 13:08:21 CST
![]() |
![]() |