se lect * from (Se lect Row_Number() Over(Order by [_Identify]) As RowNum,*,round(([ResultMoney] - 开piao金额),2) as 未开piao金额,round(([ResultMoney] - 收款金额),2) as 未收款金额 From ([dbo].[OrderMain] a left join (se lect Order_ID,round(SUM([TotalTax]),2) as 开piao金额 from [dbo].[InvoDetailed] GROUP BY [Order_ID]) b on a._Identify = b.Order_ID) left join (se lect Order_ID,SUM([AmountPay]) as 收款金额 from [dbo].[ReExpend] GROUP BY [Order_ID]) c ON a._Identify = c.Order_ID where a.Cl_PurSaleMold = 1) as aaa WHERE Row_Number >= 1 And Row_Number <= 10 ORDER BY Order_Date desc |