like query

[Naresh Kakkad]

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