Re: Joins

From: mhy <mhy_at_dhm.mhn.de>
Date: 1997/06/04
Message-ID: <3395A102.69E4@dhm.mhn.de>#1/1

eb_at_nesa1.uni-siegen.de wrote:
>
> 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));

select distinct * from calls, tools, customers where customer.kno=tools.kno(+) and tools.sno=calls.sno(+) and kname1=<xxx>

(+) means: fill records with NULL if no match Received on Wed Jun 04 1997 - 00:00:00 CDT