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`.`j_a2` `j1` join `co-operativebank`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
md5=9353d694a83ea86233d4e5a7f7ea8625
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-12-12 03:43:56
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`.`j_a2` `j1` join `co-operativebank`.`balrec` `j2` where (`j1`.`Acc_No` = `j2`.`acc_no`) group by `j2`.`acc_no`
