SQL order 语法错误 帮看看是那里的问题

SELECT T1.[DocNum], T1.[ItemCode], T0.[ItemName], T1.[PlannedQty], T2.[ItemCode], T3.[ItemName], T2.[PlannedQty] FROM OITM T0 inner join OWOR T1 on T0.[ItemCode] = T1.[ItemCode] INNER JOIN WOR1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN OITM T3 ON T2.ItemCode = T3.ItemCode WHERE T1.[U_pr01] like '[%0]%' and T1.[U_pr02] like '[%1]%' and T1.[U_pr03] like '[%2]%' and T1.[DueDate] = '[%3]' and t2.itemcode not like 'f00%' and T1.[Status]<>'c' order by t1.docnum ASC, T2.[ItemCode] DESC

这样就正确了，有两个或者多个条件排序的时间你就直接放在order by 中间即可
SELECT T1.[DocNum], T1.[ItemCode], T0.[ItemName], T1.[PlannedQty], T2.[ItemCode], T3.[ItemName], T2.[PlannedQty]
FROM OITM T0 inner join OWOR T1 on T0.[ItemCode] = T1.[ItemCode]
INNER JOIN WOR1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN OITM T3 ON T2.ItemCode = T3.ItemCode
WHERE T1.[U_pr01] like '[%0]%' and T1.[U_pr02] like '[%1]%'
and T1.[U_pr03] like '[%2]%' and T1.[DueDate] = '[%3]'
and t2.itemcode not like 'f00%' and T1.[Status]<>'c'
order by t1.docnum ,T2.[ItemCode] DESC

楼上几个的说法改变了排序顺序，应该成下面的SQL

SELECT T1.[DocNum], T1.[ItemCode], T0.[ItemName], T1.[PlannedQty], T2.[ItemCode], T3.[ItemName], T2.[PlannedQty] FROM OITM T0 inner join OWOR T1 on T0.[ItemCode] = T1.[ItemCode] INNER JOIN WOR1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN OITM T3 ON T2.ItemCode = T3.ItemCode WHERE T1.[U_pr01] like '[%0]%' and T1.[U_pr02] like '[%1]%' and T1.[U_pr03] like '[%2]%' and T1.[DueDate] = '[%3]' and t2.itemcode not like 'f00%' and T1.[Status]<>'c' order T2.[ItemCode] DESC , t1.docnum

本文如未解决您的问题请添加抖音号：51dongshi（抖音搜索懂视），直接咨询即可。