MySQL Forums
Forum List  »  Informix

like query
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



Thanks,
Naresh

Options: ReplyQuote


Subject
Views
Written By
Posted
like query
45408
May 15, 2008 07:33AM
6005
June 09, 2009 04:07AM


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.