TYPE=VIEW
query=select `v`.`Acc_no` AS `acc_no`,concat(`j`.`fname`,\' \',`j`.`mname`,\' \',`j`.`lname`) AS `name`,`j`.`father_name` AS `father_name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `SavingBal` from `co-operativebank-198`.`voucher` `v` join `co-operativebank-198`.`shares` `s` join `co-operativebank-198`.`j_a` `j` where ((`j`.`Acc_No` = `v`.`Acc_no`) and (`v`.`Acc_no` = `s`.`acc_no`) and (`v`.`sub_head` = \'14101\') and (`v`.`date` <= \'2022-03-31\')) group by `v`.`Acc_no`
md5=97bcb3b28c850e256d79d96c58b7c2ec
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2022-08-01 15:33:11
create-version=1
source=select v.acc_no,concat(fname,\' \',mname,\' \',lname) as name, father_name, (sum(cr)-sum(dr)) as SavingBal from voucher v,shares s,j_a j where j.acc_no=v.acc_no and v.acc_no=s.acc_no and sub_head=\'14101\' and v.date<=\'2022-03-31\' 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`,concat(`j`.`fname`,\' \',`j`.`mname`,\' \',`j`.`lname`) AS `name`,`j`.`father_name` AS `father_name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `SavingBal` from `co-operativebank-198`.`voucher` `v` join `co-operativebank-198`.`shares` `s` join `co-operativebank-198`.`j_a` `j` where ((`j`.`Acc_No` = `v`.`Acc_no`) and (`v`.`Acc_no` = `s`.`acc_no`) and (`v`.`sub_head` = \'14101\') and (`v`.`date` <= \'2022-03-31\')) group by `v`.`Acc_no`
