第一个sql语句

select companyname gsmc,zb zhibiaofrom t_gsndzb left join t_companycodeon t_gsndzb.gsbh=t_companycode.companyid

查询结果：

第二个sql语句

SELECT min(companyname) gsmc,cast(round(sum(t_xstj.hsje)/10000,2) as numeric(20,2)) ndje FROM t_xstj left join t_companycode on t_companycode.companyid = t_xstj.gsbhwhere datediff(year,sj,getdate())=0 group by gsbh

查询结果：

合并成一张表的语句：

select isnull(a.gsmc,b.gsmc) gsmc,isnull(a.zhibiao,0) zhibiao,isnull(b.ndje,0) ndjefrom ( --第二个表查询结果-- select companyname gsmc,zb zhibiao from t_gsndzb left join t_companycode on t_gsndzb.gsbh=t_companycode.companyid ) A FULL JOIN ( --第二个表查询结果-- SELECT min(companyname) gsmc, cast(round(sum(t_xstj.hsje)/10000,2) as numeric(20,2)) ndje FROM t_xstj left join t_companycode on t_companycode.companyid = t_xstj.gsbh where datediff(year,sj,getdate())=0 group by gsbh) b on a.gsmc=b.gsmc

结果：