SEO

#1 (**permalink**) 02-24-2008, 04:54 PM

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

#2 (**permalink**) 02-24-2008, 04:54 PM

On 8 Oct 2005 03:38:32 -0700, "Monty" <mmontreaux@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

#3 (**permalink**) 02-24-2008, 04:59 PM

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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Oracle join syntax