关于结果集联接的问题
各位高手,我有一张表存储大量信息,我现在想要以下两段代码所列出的结果集合并在一起,请问应该怎样写
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