Re: LEFT JOIN in oracle

From: andrewst <member14183_at_dbforums.com>
Date: Fri, 04 Apr 2003 11:08:31 +0000
Message-ID: <2728930.1049454511@dbforums.com>

Originally posted by Eirik Eldorsen
> What is the syntax for a LEFT JOIN in oracle?
>
> In my database book this syntax is shown wihich is not for oracle:
> SELECT b.*, p.*
> FROM Branch b LEFT JOIN PropertyForRent p ON b.bCity = p.pCity
>
> Eirik Eldorsen

Oracle supports that syntax in 9i. Oracle's own syntax is:

SELECT b.*, p.*
FROM Branch b, PropertyForRent p
WHERE b.bCity = p.pCity (+)

--
Posted via http://dbforums.com

Received on Fri Apr 04 2003 - 05:08:31 CST