两个表
字段 类别 数值 字段 数值
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里面写。大概这样