select brandname,brandimage
from trncompanyprod_forsearch a
inner join mstbrands_forsearch b on a.brandid=b.brandid
where CompanyID = '887711' and a.isproductapproved ='1' group by brandname
Products of DR. AHMED PHARMACY - E-Showroom in Dubai Yellow Pages Online
