建视图以后group by 后我也只能得到SUM(D)和SUBM(E)啊,建视图不也是写sql么,所以我想知道sql怎么写,谢谢!
已经OK了,大家可以进来拿分了 SELECT A.YYear, A.YCusPlanId, SUM(B.YgasAmount) AS YgasAmount, SUM(B.YUseDays) AS YUseDays FROM CUS_PLAN_YEAR A LEFT JOIN CUS_PLAN_YEAR_DETAIL B ON A.YCusPlanId=B.YCusPlanId GROUP BY A.YCusPlanId, A.YYear
分开求, select * from select sum(d),y from a,b where a.x=b.c as tb1, select sum(e),y from a,b where a.x=b.c as tb2 tb1.y=tb2.y
然后把视图group by
SELECT A.YYear, A.YCusPlanId, SUM(B.YgasAmount) AS YgasAmount, SUM(B.YUseDays) AS YUseDays FROM CUS_PLAN_YEAR A LEFT JOIN CUS_PLAN_YEAR_DETAIL B ON A.YCusPlanId=B.YCusPlanId GROUP BY A.YCusPlanId, A.YYear
select * from
select sum(d),y from a,b where a.x=b.c as tb1,
select sum(e),y from a,b where a.x=b.c as tb2
tb1.y=tb2.y