Question

如何并列显示出SQL查询结果

SELECT bb.dwmc,SUM(je4),count(*),ygxz from jz2014 aa,dwdm bb group by aa.kmdm,aa.ygxz where aa.kmdm=bb.kmdm and je4>0 and ygxz='劳'
+
SELECT bb.dwmc,SUM(je4),count(*),ygxz from jz2014 aa,dwdm bb group by aa.kmdm,aa.ygxz where aa.kmdm=bb.kmdm and je4>0 and ygxz='合'

如何让结果并列显示出来，例如放炮队，合的25人，劳的23人，合的金额100，劳的金额120这种结果

Answer 1

select a.dwmc,a.ygxz,sum(a.合) 合, sum(a.合人) 合人,sum(a.劳) 劳,sum(a.劳人) 劳人 from(
SELECT bb.dwmc,ygxz,SUM(je4) 合,count(*) 合人, 0 劳,0 劳人 from jz2014 aa,dwdm bb group by aa.kmdm,aa.ygxz where aa.kmdm=bb.kmdm and je4>0 and ygxz='劳'
union all
SELECT bb.dwmc,ygxz,0 合,0 合人,SUM(je4) 劳,count(*) 劳人 from jz2014 aa,dwdm bb group by aa.kmdm,aa.ygxz where aa.kmdm=bb.kmdm and je4>0 and ygxz='合'
) a group by a.dwmc,a.ygxz

追问

谢谢你的回答，但是你的回答没有运行起来，很郁闷。有QQ吗？我加一下你。我的10417837