|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
(select M_mzddgl.fID as D1, M_ddfypc.D12 as D12,M_ddfypc.D3 as D3,M_mzddgl.MD5 as MD5,M_ddfypc.D4 as D4,G_kehu.k2 as k2,M_ddfypc.D5 as D5,M_ddfypc.D6 as D6,M_ddjsmz.C2 as C2,M_ddjsmz.C5 as C5,M_ddjsmz.C6 as C6,M_ddjsmz.C7 as C7
from M_ddfypc M_ddfypc
left join M_mzddgl M_mzddgl on M_ddfypc.D1 = M_mzddgl.fID
left join M_ddjsmz M_ddjsmz on M_ddjsmz.FYID = M_ddfypc.fID
left join G_kehu G_kehu on G_kehu.k1 = M_mzddgl.MD4 )
union ( select a.D1 as D1, '' as D12,'合计' as D3, M_mzddgl.MD5 as MD5,a.D4 as D4,kh.k2 as k2, b.D5 as D5,b.D6 as D6,c.C2 as C2,d.C5 as C5,e.C6 as C6,f.C7 as C7 from M_mzddgl M_mzddgl,
(select M_mzddgl.fID as fid, G_kehu.k2 as k2 from G_kehu G_kehu,M_mzddgl M_mzddgl where G_kehu.k1 = M_mzddgl.MD4) kh, --客户名称 k2
(select M_ddfypc.D1 as D1, SUM(M_ddfypc.D4) as D4 from M_ddfypc M_ddfypc group by M_ddfypc.D1) a, --总车数 D4
(select M_ddfypc.D1 as D1,sum(M_ddfypc.D5) as D5,SUM(M_ddfypc.D6) as D6 from M_ddfypc M_ddfypc group by M_ddfypc.D1) b, --总发运量 D5,总结算量 D6
(select M_ddjsmz.C1 as C1, sum(M_ddjsmz.C2*M_ddfypc.D6)/SUM(M_ddfypc.D6) as C2
from M_ddjsmz M_ddjsmz,M_ddfypc M_ddfypc where M_ddjsmz.FYID=M_ddfypc.fID group by M_ddjsmz.C1) c, --加权平均全水 C2
(select M_ddjsmz.C1 as C1, sum(M_ddjsmz.C5*M_ddfypc.D6)/SUM(M_ddfypc.D6) as C5
from M_ddjsmz M_ddjsmz,M_ddfypc M_ddfypc where M_ddjsmz.FYID=M_ddfypc.fID group by M_ddjsmz.C1) d, --加权平均灰分 C5
(select M_ddjsmz.C1 as C1, sum(M_ddjsmz.C6*M_ddfypc.D6)/SUM(M_ddfypc.D6) as C6
from M_ddjsmz M_ddjsmz,M_ddfypc M_ddfypc where M_ddjsmz.FYID=M_ddfypc.fID group by M_ddjsmz.C1) e, --加权平均灰分 C6
(select M_ddjsmz.C1 as C1, sum(M_ddjsmz.C7*M_ddfypc.D6)/SUM(M_ddfypc.D6) as C7
from M_ddjsmz M_ddjsmz,M_ddfypc M_ddfypc where M_ddjsmz.FYID=M_ddfypc.fID group by M_ddjsmz.C1) f --加权平均灰分 C7
where a.D1=b.D1 and a.D1=c.C1 and a.D1=d.C1 and a.D1=e.C1 and a.D1=f.C1 )
这是我用sql写的语句, SQL支持union 吗,怎么才能合到一起
|
-
这是我要实现的效果,合计是另加上去的
|