数据库视图写法求助
两个表

字段 类别  数值                        字段    数值
a     b     555                         a       666
a     c     666                         a      777
a     d     777                         a       888
a     e     888                         f       999                     

怎样用视图算出表1所有字段为a的数值总和和表2字段为a的数值总和
------解决方案--------------------

create view V_name

as

with a1 as

(select columna,sum(columnc) c1 from t group by columna)

,a2 as

(select columna1,sum(columnc) c2 from t1 group by columna1)

select a1.columna,a1.c1,a2.c2 from a1 inner join a2 

on a1.columna=a2.columna1

没有在ssms里面写。大概这样