多了一个括号，自己排版代码检查
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] as a
left join (se lect Order_ID,round(SUM([TotalTax]),2) As 开piao金额 from [dbo].[InvoDetailed] GROUP BY [Order_ID]) As b on a.[_Identify] = b.Order_ID
left join (se lect Order_ID,SUM([AmountPay]) As 收款金额 from [dbo].[ReExpend] GROUP BY [Order_ID]) As 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
另外_Identify要加上中括号
最后还是提醒一下，尽量不要使用自增主键_Identify做业务关联，以后换服务器做数据迁移，不小心的话可能会撞大彩
加好友 
发短信
Post By：2021/4/29 10:59:00 [显示全部帖子]
