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=42514 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are GMP certified Manufacturer of Pharma formulations for both Human and Veterinary use.Please note taht we can supply all varieties of Veterinary medicines.Please visit www.smithkenner.com