Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: JOIN Statements

Re: JOIN Statements

From: <gbailey_at_oakwoodsys.com>
Date: Mon, 11 Jan 1999 19:08:21 GMT
Message-ID: <77di72$350$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US