Accessת³ÉMSSQLºó²éѯ³öÏÖ´íÎó

´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for SQL Server (0x80040E14)
³ý·Çͬʱָ¶¨ÁË TOP£¬·ñÔò ORDER BY ×Ó¾äÔÚÊÓͼ¡¢ÄÚǶº¯Êý¡¢ÅÉÉú±íºÍ×Ó²éѯÖÐÎÞЧ¡£
/cnblms/index_2/Order_show.asp, µÚ 94 ÐÐ


ÉÏÃæÊÇä¯ÀÀÆ÷¸ø³öµÄ´íÎó¡£ÎÒÊǵÚÒ»´ÎתÊý¾Ý¿â£¬Óöµ½ÕâÖÖÇé¿ö»¹Õæ²»ÖªµÀÔõôÏÂÊÖ£¬ÍøÉÏÓкö඼³öÏÖÁËÕâÑùµÄ´íÎ󣬿ÉÎÒ¿´¿´²»ÏñÎÒÕâÖÖ¡£

ÇóÄÄλºÃÐÄÈ˸ø³ö³ö×¢Ò⣡£¡

Ìù³ö´úÂ룺
SQL code:

sqlOrder1 ="SELECT Top 1 A.ProductionID, A.ProductionNO, A.Title, A.Price,A.Price1, A.Unit,O.OrderNO,O.OrderID,O.UpdateTime,"
sqlOrder1 = sqlOrder1 & "O.PaymentMode, O.Num, O.UserID, A.Price*O.Num AS [Count],A.Price1*O.Num AS Count1,O.Memo, U.UserName,U.TrueName,U.MobilePhone,U.Phone,U.Address "
sqlOrder1 = sqlOrder1 & "from (Production AS A INNER JOIN [Order] AS O ON A.ProductionID = O.ProductionID) "
sqlOrder1 = sqlOrder1 & "INNER JOIN [User] AS U ON (U.UserID = O.UserID) WHERE A.Deleted=0 AND O.OrderNO ='"& OrderNO &"' Order by O.OrderID desc"
Set rsOrder1 = server.CreateObject("Adodb.recordset")
rsOrder1.open sqlOrder1,conn2,1,1

sqlOrder2 = "Select Sum(Count) AS Total,Sum(Count1) AS Total1 from ("
sqlOrder2 = sqlOrder2 & "SELECT A.ProductionID, A.ProductionNO, A.Title, A.