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 , 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 40832 Naresh Kakkad 05/15/2008 07:33AM
Re: like query 4562 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.