SELECT a.StandardID,a.ProductName_e,b.icount FROM t_standard a left join (select count(id) as iCount,max(StandardID) as StandardID from Tproduct where userid=11028 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are an Indian company engaged in manfuacturing, marketing, international distribution of poultry, cattle, pet and equine products. We are working in India as well as outside through our own dedicated team of business professionals, vets and consultants.