Re: Oracle join syntax

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 12 Oct 2005 21:15:42 +0200
Message-ID: <dijmsp$ptk$1@news1.zwoll1.ov.home.nl>

Monty 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%';
>

Your version understands ANSI Join syntax, so it should not be necessary to translate

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Oct 12 2005 - 14:15:42 CDT