mysql - MySQL Union Statement 不起作用，正在努力寻找原因

Question

我正在尝试将两个表与 UNION 语句结合起来。我正在匹配两个表的列。我不明白这个问题是什么。

没有给出语法错误。

预期结果

Table B1:

id   Date            DR_code      DR_code     CR     CR_code
ob3  2019-12-31      B1           20000       0   
*then all values in table B1*

Table B2:

id   Date            DR_code      DR_code     CR     CR_code
ob4  2019-12-31      B2           1000       0   
*then all values in table B2*

谢谢你的帮助

MySQL 版本 14.14 分布 5.7.23

# for loop below creates strings: B1 and B2
for bank in Bank_Account_Code:
    with engine.connect() as con:
        con.execute('''
        SELECT id, Date, DR_code, DR, CR, CR_code FROM '''+bank+'''
        UNION ALL
        SELECT id, Date, DR_code, DR, CR, CR_code FROM Opening_Balances
        WHERE DR_code="'''+bank+'''"
        ;''')
        con.execute('''
        SELECT id, Date, DR_code, DR, CR, CR_code FROM '''+bank+'''
        UNION ALL
        SELECT id, Date, DR_code, DR, CR, CR_code FROM Opening_Balances
        WHERE CR_code="'''+bank+'''"
        ORDER BY DATE
        ;''')

标签： mysqlsqlmysql-python