select t1.FCodeSelf,t1.FName,isnull(t2.FAmount,0) FAmount,isnull(t2.FRevenue,0)FRevenue,isnull(t4.FAmountOld,0)FAmountOld,isnull(t4.FRevenueOld,0)FRevenueOld,isnull(t3.FPerf,0)FPerf,isnull(t3.FPortfolio,0)FPortfolio from select t1.FCodeSelf,t1.FName,isnull(t2.
阅读背景：
【求助】sql server 查询 最后一行增加汇总
来源：互联网
select t1.FCodeSelf,t1.FName,isnull(t2.FAmount,0) FAmount,isnull(t2.FRevenue,0)FRevenue,isnull(t4.FAmountOld,0)FAmountOld,isnull(t4.FRevenueOld,0)FRevenueOld,isnull(t3.FPerf,0)FPerf,isnull(t3.FPortfolio,0)FPortfolio from select t1.FCodeSelf,t1.FName,isnull(t2.
分享到：
