Re: Oracle join syntax

On 8 Oct 2005 03:38:32 -0700, "Monty" <mmontreaux_at_hotmail.com> wrote:

>10.1.0.2, Windows 2000
>
>I am migrating a customer service application from Access to Oracle. I
>cannot translate the join syntax of Access. Can someone translate this
>to Oracle please using (+).
>
>Monty
>
>
>SELECT addrs.ID, cust.*
>FROM (addrs INNER JOIN cust ON addrs.ID = cust.ID) INNER JOIN operators
>ON cust.updatedBy = operators.ID WHERE addrs.Name LIKE '%IBM%';

The plus sign signifies an OUTER join, so it doesn't apply to an INNER join.

select addr.id, cust.*
from addrs, cust, operators
where addrs.id = cust.id and cust.updatedby = operators.id and addrs.name like '%IBM%'

--
Sybrand Bakker, Senior Oracle DBA