Z4u3z1 回复 Q4512K41FF(提问者)每一列都要有列名
select \'\' [未知],\'上期余额\',sum(isnull(itranfee,0)) as 运费,Sum(iqt)as 其他 ,Sum(ithquantity) as 退货,Sum(ihkmoney) as 收款,Sum(imoney_in) as 销售额,NULL [未知2],null [未知3]
,sum(isnull(imoney_in,0))+sum(isnull(itranfee,0))- sum(isnull(ihkmoney ,0))+sum(isnull(ithquantity ,0))
+sum(isnull(iqtfee ,0))+sum(isnull(iqtfee_xj ,0))+sum(isnull(iqt ,0))+sum(case when cdigest=\'上期余额\' then isnull(imoney_jc,0) else 0 end) as imoney_jc,\'\' ccuscode
from myalldata..my_dzd1 WITH (NOLOCK)
where headccuscode=\'000001\' and year(ddate)>=\'${yearpara}\' and ddate>=\'2017\'
UNION ALL