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

Home -> Community -> Usenet -> c.d.o.server -> Oracle join syntax

Oracle join syntax

From: Monty <mmontreaux_at_hotmail.com>
Date: 8 Oct 2005 03:38:32 -0700
Message-ID: <1128767912.628912.202620@o13g2000cwo.googlegroups.com>


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%'; Received on Sat Oct 08 2005 - 05:38:32 CDT

Original text of this message

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