Posted by: Naresh Kakkad
Date: May 15, 2008 07:33AM
want to fetch data from three table to have the relation but one of the table as field owner_name and another as first name and last name how to solve this type of query
select si.*,co.firstname as cofname , co.lastname as colname , co.city as cocity ,sr.firstname as srfname, sr.lastname as srlname from sales_info as si,company_owner as co, sales_rep as sr where si.user_id=sr.user_id and sr.owner_name like '%co.firstname%lastname%' and sr.owner_name IN ( SELECT co.firstname FROM company_owner ) and si.type='ipod' and co.distributor_name='Ingram Micro' order by si.date, si.type ASC
please reply ASAP
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.