Skip navigation links

MySQL Forums :: Informix :: like query

Advanced Search

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

Subject Views Written By Posted
like query 41791 Naresh Kakkad 05/15/2008 07:33AM
Re: like query 4824 arvind nagar 06/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.