关于SQL查询的问题

uncle0

1. import pymssql
   
2. PL ='ooA5'
   
3. Stock = '1,2,3,4'
   
4. conn = pymssql.connect(server='AA', user='sa', password='FF', database='CC',
   
5.                                charset='utf8')
   
6. sql = "select a.productID,fullName,b.storageName," \
   
7.       "convert(int,isnull(d.orderAmount,0)) as orderAmount," \
   
8.       "convert(int,isnull(d.roadamount,0)) as roadamount," \
   
9.       "convert(int,isnull(d.amount,0)) as amount," \
   
10.       "convert(int,isnull(d.money,0)) as money " \
    
11.       "from EIM_BSS_Basic_Products a cross join " \
    
12.       "EIM_BSS_Basic_Storage b join " \
    
13.       "EIM_BSS_Stat_ProductStorage c on a.productID=c.productID Left join " \
    
14.       "EIM_BSS_Stat_ProductSubStorage d on a.productID=d.productID and b.storageID=d.storageID Left join " \
    
15.       "EIM_BSS_Basic_ProductCategories e on a.productCategoryID=e.productCategoryID Left join " \
    
16.       "EIM_BSS_Basic_ProductCategories f on left(a.productCategoryID,4)=f.productCategoryID " \
    
17.       "where left(a.productCategoryID,4) = %s and b.storageid in (%s)" \
    
18.       "order by fullName ,left(a.productCategoryID,4),a.productCategoryID,a.productid,b.storageID"
    
19. cursor0 = conn.cursor()  # 创建游标0
    
20. cursor0.execute(sql,(PL,Stock))  # 执行sql
    
21. sqlData = cursor0.fetchall()
    
22. cursor0.close()
    
23. conn.close()
    
24. print(sqlData)

复制代码

谁能帮忙解释下为什么一直错吗？放入一个参数就可以，2个就不行了。

wp231957

这款sql没用过，建议你先在数据库环境里通过
或者navicat里也能测试