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` from `co-operativebank-234`.`j_a2` `j1` join `co-operativebank-234`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
md5=04d4e49e2a53060cf0efd97efe416409
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-12-18 13:15:13
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 FROM `j_a2` j1,balrec j2 WHERE j1.acc_no=j2.acc_no group by j2.acc_no
client_cs_name=utf8
connection_cl_name=utf8_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` from `co-operativebank-234`.`j_a2` `j1` join `co-operativebank-234`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
