语句：SqlStr="Select I.UserName,I.id,I.ProID,I.OrderID,I.status,I.orderid,I.inputtime,I.NoUseCouponMoney,I.MoneyTotal,I.MoneyReceipt,I.NeedInvoice,I.DeliverStatus,L.KS_dizhi,A.ID From KS_OrderItem A Left Join KS_Order I On A.ID=I.Id  right inner Join KS_Product L On I.ProID=L.Id " & Param & " order by I.id desc"
       Set RS=Server.createobject("adodb.recordset")
       RS.open SqlStr,conn,1,1

错误：

错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'A.ID=I.Id right inner Join KS_Product L On I.ProID=L.Id' 中。
/User/user_order.asp, 第 105 行

SqlStr="Select I.UserName,I.id,I.ProID,I.OrderID,I.status,I.orderid,I.inputtime,I.NoUseCouponMoney,I.MoneyTotal,I.MoneyReceipt,I.NeedInvoice,I.DeliverStatus,L.KS_dizhi,A.ID From KS_OrderItem A Left Join KS_Order I On A.ID=I.Id" & Param & " order by I.id desc"
       Set RS=Server.createobject("adodb.recordset")
       RS.open SqlStr,conn,1,1

这样查询两个表是正常的