数据都为数字表A
字段A1 A2 A3
10 20 30表B
字段B1 B2 B3
40 11 50
40 22 60
表C
字段C1 C2 C3
70 80 90想得到一个视图totalview,
包括如下字段:
A3汇总
根据B2 分类汇总B3
C3的汇总。具体为
字段A3 11 22 C3
30 50 60 90偶已经晕了。请大家指点。谢谢!
字段A1 A2 A3
10 20 30表B
字段B1 B2 B3
40 11 50
40 22 60
表C
字段C1 C2 C3
70 80 90想得到一个视图totalview,
包括如下字段:
A3汇总
根据B2 分类汇总B3
C3的汇总。具体为
字段A3 11 22 C3
30 50 60 90偶已经晕了。请大家指点。谢谢!
详细说明
select a3,
(select b3 from b where b2=11) as 11,
(select b3 from b where b2=22) as 22,
(select c3 from c ) as c3
from a
or
select a3,
(select sum(b3) from b where b2=11) as 11,
(select sum(b3) from b where b2=22) as 22,
(select sum(c3) from c ) as c3
from a