TYPE=VIEW
query=select `v`.`Acc_no` AS `acc_no`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `openbal`,0 AS `dueamt` from `co-operativebank-dkmadhabpur`.`voucher` `v` join `co-operativebank-dkmadhabpur`.`shg_subsidy_f` `f` where ((`v`.`Acc_no` = `f`.`acc_no`) and (`v`.`date` <= \'2021-08-26\') and (`v`.`sub_head` = \'23113\')) group by `v`.`Acc_no` union all select `v`.`Acc_no` AS `acc_no`,0 AS `openbal`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `dueamt` from `co-operativebank-dkmadhabpur`.`voucher` `v` join `co-operativebank-dkmadhabpur`.`shg_subsidy_f` `f` where ((`v`.`Acc_no` = `f`.`acc_no`) and (`v`.`date` <= \'2022-08-26\') and (`v`.`sub_head` = \'23113\')) group by `v`.`Acc_no`
md5=b5390482fb0695091242e86307dbfc12
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-08-26 09:19:23
create-version=1
source=SELECT v.acc_no,(sum(dr)-sum(cr)) as openbal,0 as dueamt FROM voucher v,shg_subsidy_f f WHERE v.acc_no=f.acc_no and v.date<=\'2021-08-26\' and sub_head=\'23113\' group by v.acc_no union all SELECT v.acc_no,0 as openbal, (sum(dr)-sum(cr)) as dueamt FROM voucher v,shg_subsidy_f f WHERE v.acc_no=f.acc_no and v.date<=\'2022-08-26\' and sub_head=\'23113\' group by v.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`Acc_no` AS `acc_no`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `openbal`,0 AS `dueamt` from `co-operativebank-dkmadhabpur`.`voucher` `v` join `co-operativebank-dkmadhabpur`.`shg_subsidy_f` `f` where ((`v`.`Acc_no` = `f`.`acc_no`) and (`v`.`date` <= \'2021-08-26\') and (`v`.`sub_head` = \'23113\')) group by `v`.`Acc_no` union all select `v`.`Acc_no` AS `acc_no`,0 AS `openbal`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `dueamt` from `co-operativebank-dkmadhabpur`.`voucher` `v` join `co-operativebank-dkmadhabpur`.`shg_subsidy_f` `f` where ((`v`.`Acc_no` = `f`.`acc_no`) and (`v`.`date` <= \'2022-08-26\') and (`v`.`sub_head` = \'23113\')) group by `v`.`Acc_no`
