| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle join syntax
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
 |
 |