从使用connection.curs创建的Django中的显示表中删除

Question

我使用SOURCE表中的connection.cursor显示了两个表（即table1和table2）

问题：

现在我必须减去table1(fields)-table2(fields)，并将输出显示为table3

节目：

IN views.py

cursor1.execute('''select dummy as LCR_CUSTOMER_TYPE,CUR AS CURRENCY,'$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_NONOP_INS))) as LCR_NONOP_INS, '$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_OP_INS))) as LCR_OP_INS, '$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_NONOP_UNINS)))as LCR_NONOP_UNINS, '$'+CONVERT(VARCHAR(20), CONVERT(MONEY,sum(LCR_OP_UNINS)))as LCR_OP_UNINS from (select *,(case when LCR_CUSTOMER_TYPE='Corporate' then 'Non-Credit Financial Entities'else LCR_CUSTOMER_TYPE end) as dummy from   DDA_BASED_S9_20150930) a group by CUR,dummy''')                                            cursor.execute('''select AFTERMEMO,CUR AS CURRENCY,'$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_NONOP_INS))) as LCR_NONOP_INS,'$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_OP_INS))) as LCR_OP_INS, $'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_NONOP_UNINS))) as LCR_NONOP_UNINS, '$'+CONVERT(VARCHAR(20), CONVERT(MONEY, sum(LCR_OP_UNINS))) as LCR_OP_UNINS from (select *,(case when SIC_CODE = 7215 and LCR_CUSTOMER_TYPE = 'Non-Credit Financial Entities' then 'NonFinancialCorp' when LCR_CUSTOMER_TYPE = 'Corporate' then 'Non-Credit Financial Entities' else LCR_CUSTOMER_TYPE end) as AFTERMEMO from  DDA_BASED_S9_20150930) a group by  CUR,AFTERMEMO''')

TABLE3=TABLE1-TABLE2

谁能告诉我怎么做…这会很有帮助的，谢谢