create view AllOrder as
select Name,sum(A2.Number) Number
from AllOrder A1 left join (
select * from DsOrder
UNION ALL(select * from DhOrder)
UNION ALL(select * from XlOrder)
UNION ALL(select * from XsOrder)
)as A2
on A1.Name=A2.Name
select Name,sum(A2.Number) Number
from AllOrder A1 left join (
select * from DsOrder
UNION ALL(select * from DhOrder)
UNION ALL(select * from XlOrder)
UNION ALL(select * from XsOrder)
)as A2
on A1.Name=A2.Name
select A2.Name,sum(A2.Number) Number
from (
select * from DsOrder
UNION ALL(select * from DhOrder)
UNION ALL(select * from XlOrder)
UNION ALL(select * from XsOrder)
)as A2
DsOrder 12 1 12-6 Ds
13 2 12-6 Ds
DhOrder 12 1 12-6 Dh
14 2 12-6 Dh
XlOrder 15 1 12-6 Xl
XsOrder 16 1 12-6 Xs结果是:
AllOrder 12 2
13 2
14 2
15 1
16 1
小弟再次感谢了
select * from DsOrder
UNION ALL(select * from DhOrder)
UNION ALL(select * from XlOrder)
UNION ALL(select * from XsOrder)
)t group by name