摘要： select t.name,sum(t.SupplierCount) from (select a.name,count(b.Supplier_Id) as SupplierCount from yxs_administrators a,yxs_drugsbase_supplier b ,yxs_product c,yxs_supplies d,yxs_drugsbase ewhere b.bstop=0 and a.adminid=b.editer and c.Supplier_Id=b.Supplier_Id and b.supplies_id=d.supplies_id and b.dr 阅读全文