如何包含多个光标。在python中执行

就像我必须从sql表中获取源、ID和目标一样,但它们存在于两个不同的表中,所以我尝试了

dom_id=[1,10,19,31,37,42,48,57,63,64,65]

for i in range(len(dom_id)):
  cursor.execute("SELECT xval, yval from table1 WHERE DOMID=?",dom_id[i])
  source=""
  for row in cursor.fetchall():
      source=float(row[0]),float(row[1])
      source=','.join(map(str, source))
  cursor.execute("select t1.id as pid,pxval,pyval from table2")
  ID=[]
  destination=""
  for row_d in cursor.fetchall():
        ID.append(row_d[0]) 
        destination = float(row_d[1]),float(row_d[2])
        destination = ','.join(map(str, destination))

现在我正在使用 for循环 提取源和其他 for循环 提取 ID 和 destination 我试过了

cursor.execute(("SELECT xval, yval from table1 WHERE DOMID=?",dom_id[i]);("select t1.id as pid,pxval,pyval from table2 t1 left join (select * from table3 where clubid=?) t2 on t1.id=t2.pid where t1.cityid in (SELECT cityid FROM table1 WHERE domid = ? group by cityid) and t1.pxval>0 and t2.distance is null order by pid",(dom_id[i],dom_id[i])))

但它会产生错误 SyntaxError: invalid syntax

有什么办法可以把两者结合起来吗 cursor.execute 在单个for循环中。 有什么建议吗?