TYPE=VIEW
query=select `j2`.`lfnof` AS `lf_no`,`j2`.`Report_Date` AS `Report_Date`,`j1`.`Acc_No` AS `acc_no`,concat(`j1`.`fname`,\' \',`j1`.`mname`,\' \',`j1`.`lname`) AS `name`,`j1`.`father_name` AS `father_name`,`j2`.`cr` AS `cr`,`j2`.`dr` AS `dr`,`j2`.`bal` AS `bal`,`j1`.`spno` AS `spno` from `co-operativebank-242`.`j_a2` `j1` join `co-operativebank-242`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
md5=a08cb384cb975f410750490e45d414b4
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-01-16 05:52:12
create-version=1
source=SELECT lfnof as lf_no, Report_Date,j1.acc_no,concat(fname,\' \',mname,\' \',lname) as name,father_name, cr, dr, bal,spno FROM `j_a2` j1,balrec j2 WHERE j1.acc_no=j2.acc_no group by j2.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `j2`.`lfnof` AS `lf_no`,`j2`.`Report_Date` AS `Report_Date`,`j1`.`Acc_No` AS `acc_no`,concat(`j1`.`fname`,\' \',`j1`.`mname`,\' \',`j1`.`lname`) AS `name`,`j1`.`father_name` AS `father_name`,`j2`.`cr` AS `cr`,`j2`.`dr` AS `dr`,`j2`.`bal` AS `bal`,`j1`.`spno` AS `spno` from `co-operativebank-242`.`j_a2` `j1` join `co-operativebank-242`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
