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 [email protected].
To post to this group, send email to [email protected].
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.
