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-198`.`j_a2` `j1` join `co-operativebank-198`.`balrec` `j2` where ((`j1`.`Acc_No` = `j2`.`acc_no`) and (`j2`.`acc_no` = \'458690\')) group by `j2`.`acc_no`
md5=7a60922785f0e7aed6ae62c116456988
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-09-26 10:41:17
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 and j2.acc_no= \'458690\' 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-198`.`j_a2` `j1` join `co-operativebank-198`.`balrec` `j2` where ((`j1`.`Acc_No` = `j2`.`acc_no`) and (`j2`.`acc_no` = \'458690\')) group by `j2`.`acc_no`
