一条SQL语句，关于ORDER BY--十分紧急

[ghost_028]

在程序中语句如下：
"SELECT \"Customers\".\"CustomerID\" FROM (\"CustomerLink\" INNER JOIN \"Customers\" ON \"Customers\".\"CustomerID\" = \"CustomerLink\".\"LinkedCustomerID\" AND \"CustomerLink\".\"ProjectID\"-1 = \"Customers\".\"ProjectID\") WHERE ([Customers].[CustomerID] = [CustomerLink].[LinkedCustomerID] AND [Customers].[ProjectID] = 15 and [CustomerLink].[ProjectID] = 16 ) ORDER BY \"Customers\".\"LastName\" ASC\"Customers\".\"FirstName\" ASC,\"Customers\".\"MiddleName\" ASC"
翻译后在查询分析器中执行：
SELECT Customers.CustomerID
FROM (CustomerLink INNER JOIN Customers ON Customers.CustomerID = CustomerLink.LinkedCustomerID AND CustomerLink.ProjectID-1 = Customers.ProjectID)
WHERE ([Customers].[CustomerID] = [CustomerLink].[LinkedCustomerID] AND [Customers].[ProjectID] = 15)
ORDER BY Customers.LastName ASC Customers.FirstName ASC,Customers.MiddleName ASC
错误信息如下：
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'Customers'.
如果去掉ORDER BY以及后面的语句，则正确

大家帮忙看看什么原因？？？

[一条晚起的虫]

ORDER BY Customers.LastName ASC Customers.FirstName ASC,Customers.MiddleName ASC
--〉
ORDER BY Customers.LastName ASC, Customers.FirstName ASC,Customers.MiddleName ASC
//少个逗号？

[尘雨]

楼上够细心

[hchen118]

好像order by 中要用逗号隔开吧？搂主不太仔细哟。呵呵