2011年12月22日
sql 数据优化 union 代替or
摘要： 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 阅读全文
posted @ 2011-12-22 15:38 That's me 阅读(334) 评论(0) 推荐(0)