TYPE=VIEW
query=select `dc`.`lf_no` AS `lf_no`,\'2024-11-07\' AS `Report_Date`,`v`.`Acc_no` AS `acc_no`,concat(`dc`.`fname`,\' \',`dc`.`mname`,\' \',`dc`.`lname`) AS `name`,`dc`.`father_name` AS `father_name`,sum(`v`.`cr`) AS `cr`,sum(`v`.`dr`) AS `dr`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal` from `co-operativebank-115`.`j_a` `dc` join `co-operativebank-115`.`voucher` `v` where ((`v`.`Acc_no` = `dc`.`Acc_No`) and (`v`.`date` >= \'2015-11-07\') and (`v`.`date` <= \'2024-11-07\') and (`v`.`sub_head` = \'14101\')) group by `dc`.`Acc_No`
md5=7397d48d315c1f19978b9792dea3e1c1
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-11-07 00:49:12
create-version=1
source=SELECT  lf_no,\'2024-11-07\' as Report_Date,v.acc_no,concat(fname,\' \',mname,\' \',lname) as name,father_name,sum(cr) as cr,sum(dr) as dr,(sum(cr)-sum(dr)) as bal FROM j_a dc,voucher v WHERE (v.acc_no=dc.acc_no)  and v.date>=\'2015-11-07\' and v.date<=\'2024-11-07\' and sub_head=\'14101\' group by dc.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `dc`.`lf_no` AS `lf_no`,\'2024-11-07\' AS `Report_Date`,`v`.`Acc_no` AS `acc_no`,concat(`dc`.`fname`,\' \',`dc`.`mname`,\' \',`dc`.`lname`) AS `name`,`dc`.`father_name` AS `father_name`,sum(`v`.`cr`) AS `cr`,sum(`v`.`dr`) AS `dr`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal` from `co-operativebank-115`.`j_a` `dc` join `co-operativebank-115`.`voucher` `v` where ((`v`.`Acc_no` = `dc`.`Acc_No`) and (`v`.`date` >= \'2015-11-07\') and (`v`.`date` <= \'2024-11-07\') and (`v`.`sub_head` = \'14101\')) group by `dc`.`Acc_No`
