TYPE=VIEW
query=select `v`.`Acc_no` AS `acc_no`,`s`.`acc_no` AS `sbacc_no`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `Sharebal` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`shares` `s` where ((`v`.`Acc_no` = `s`.`code`) and (`v`.`sub_head` = \'11200\') and (`v`.`date` <= \'2025-09-30\')) group by `v`.`Acc_no`
md5=66f42afb244126c443d031935c10e39f
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-12-17 13:42:18
create-version=1
source=select v.acc_no, s.acc_no as sbacc_no, (sum(cr)-sum(dr)) as Sharebal from voucher v,shares s where v.acc_no=s.code and sub_head=\'11200\' and v.date<=\'2025-09-30\' group by v.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `v`.`Acc_no` AS `acc_no`,`s`.`acc_no` AS `sbacc_no`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `Sharebal` from `co-operativebank-dekhaliannapurna`.`voucher` `v` join `co-operativebank-dekhaliannapurna`.`shares` `s` where ((`v`.`Acc_no` = `s`.`code`) and (`v`.`sub_head` = \'11200\') and (`v`.`date` <= \'2025-09-30\')) group by `v`.`Acc_no`
