I have dtc1 and dtc2 quite large datatables.
dtc1 has icode,total columns
dtc2 has icode,jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec,year columns.
I would like to sum jan,feb,mar for year=2011 and oct,nov,dec for year =2010 columns from dtc2 and then update dtc1 column total with it.
Icode is the common column in both datatables.
dtc1 data MPR125,0
dtc2 data MPR125,0,1,0,2,0,2,1,3,2,1,2,0,2011
please write the code for me.