2010年6月7日

先聚合再连接

摘要： string SQL = @"select isnull(i.IntegralSum,0.0)as IntegralSum,a.AccountSum,u.UserLave,u.AddTime from Bst_User uleft join (select UserId,sum(cast(IntegralCount as numeric(10,2))) as IntegralSumfrom Bst_Integral where IsOver=0 group by UserId) ion i.UserId=u.UserIdinner join (select UserId,sum(ca 阅读全文

posted @ 2010-06-07 16:39 jshchg 阅读(328) 评论(0) 推荐(0)

导航