注册 登录
编程论坛 SQL Server论坛

关于结果集联接的问题

zhanglisuo 发布于 2007-04-10 16:48, 524 次点击

各位高手,我有一张表存储大量信息,我现在想要以下两段代码所列出的结果集合并在一起,请问应该怎样写

select sj as sj,sum(sfy) as sfl
from dat_bdxx
where xtrq>='2007.03.01' and jclx='D'
group by sj,dic_sjbm.xm
order by sfl

select fsj as sj,sum(sfy) as sfl
from dat_bdxx,dic_sjbm
where xtrq>='2007.03.01' and jclx='N'
group by fsj,dic_sjbm.xm
order by sfl


1 回复
#2
Kendy1234562007-04-10 17:00

select sj as sj,sum(sfy) as sfl
from dat_bdxx
where xtrq>='2007.03.01' and jclx='D'
group by sj,dic_sjbm.xm
order by sfl

Union

select fsj as sj,sum(sfy) as sfl
from dat_bdxx,dic_sjbm
where xtrq>='2007.03.01' and jclx='N'
group by fsj,dic_sjbm.xm
order by sfl

1