我有两张桌子,sales_olap
还有resellers
我需要打印出表sales_olap
中不存在的经销商resellers
例如:
result = cursor.execute("SELECT SO.reseller_name FROM sales_olap AS SO WHERE
SO.reseller_name!=(SELECT reseller FROM resellers)")
for row in result:
print row
但我收到以下错误: 1242, Subquery returns more than 1 row
我怎样才能让它只打印sales_olap
表中不存在的resellers
表中的经销商名称?
如果我尝试这样做:
result = cursor.execute("SELECT reseller_name FROM sales_olap WHERE reseller_name NOT IN(SELECT reseller FROM resellers)")
for row in result:
print row['reseller_name']
然后我得到以下错误: TypeError: 'long' object is not iterable
能够通过这样做来使其工作:
cursor.execute("SELECT reseller_name FROM sales_olap LEFT JOIN resellers ON sales_olap.reseller_name=resellers.reseller WHERE resellers.reseller IS NULL")
result = cursor.fetchall()
for row, in result:
print (row)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句