subtract two tables created by connection.cursor and display output on webpage

I have displayed two tables on web(i.e table1 and table2) using connection.cursor from SOURCE table   ISSUE:   Now I have to subtract table1(fields)-table2(fields) and display the output as table3.    so final web page will have table1,table2,table3   PROGRAM:   IN views.py   #table 1   cursor1=connection.cursor()     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 ''')     list=cursor1.fetchall(); --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------       #table 2     cursor = connection.cursor()     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 ''') list1=cursor.fetchall(); TABLE3=TABLE1-TABLE2 can anyone tell me how to do this...it will be very helpful   thanks in advance

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1d325343-5f68-49e5-a918-a3b51da08acb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.