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 , 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.type ASC

please reply ASAP


Options: ReplyQuote

Written By
like query
May 15, 2008 07:33AM
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.