| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Joins
How can I tranlate this view to Oracle (Joins). It will be great to hear from you
SELECT DISTINCTROW Calls.*, Tools.*, Customer.*
FROM (Customer LEFT JOIN Tools ON Customer.KNo = Tools.KNo) LEFT JOIN
Calls ON Tools.SNo = Calls.SNo
WHERE (Customer.KName1= XXX));
Received on Thu Jun 05 1997 - 00:00:00 CDT
 |
 |