TYPE=VIEW
query=select `f`.`date_open` AS `date_open`,`f`.`acc_no` AS `acc_no`,`f`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`f`.`name` AS `name`,`f`.`interest` AS `interest`,`f`.`max_dt` AS `max_dt`,`f`.`int_amt` AS `int_amt`,`f`.`subsidy` AS `subsidy`,`f`.`sblfno` AS `sblfno`,`f`.`llfno` AS `llfno`,`f`.`father_name` AS `father_name`,`f`.`address` AS `address`,`f`.`bankacc` AS `bankacc`,`f`.`mobile` AS `mobile`,`f`.`adhar` AS `adhar`,`f`.`status` AS `status`,`f`.`eft` AS `eft`,`f`.`fdt` AS `fdt`,`f`.`groupno` AS `groupno`,sum(`l`.`openbal`) AS `openbal`,sum(`l`.`dueamt`) AS `Due_Amt` from `co-operativebank-199`.`shg_subsidy_f` `f` join `co-operativebank-199`.`shg_subsidy_f4` `l` where (`l`.`acc_no` = `f`.`acc_no`) group by `l`.`acc_no`
md5=4ed5ee4298e48a7e36192e5ee74b36ca
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-05-13 12:03:37
create-version=1
source=SELECT f.*,sum(openbal) as openbal,sum(dueamt) as Due_Amt FROM `shg_subsidy_f` f,shg_subsidy_f4 l where l.acc_no=f.acc_no   group by l.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `f`.`date_open` AS `date_open`,`f`.`acc_no` AS `acc_no`,`f`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`f`.`name` AS `name`,`f`.`interest` AS `interest`,`f`.`max_dt` AS `max_dt`,`f`.`int_amt` AS `int_amt`,`f`.`subsidy` AS `subsidy`,`f`.`sblfno` AS `sblfno`,`f`.`llfno` AS `llfno`,`f`.`father_name` AS `father_name`,`f`.`address` AS `address`,`f`.`bankacc` AS `bankacc`,`f`.`mobile` AS `mobile`,`f`.`adhar` AS `adhar`,`f`.`status` AS `status`,`f`.`eft` AS `eft`,`f`.`fdt` AS `fdt`,`f`.`groupno` AS `groupno`,sum(`l`.`openbal`) AS `openbal`,sum(`l`.`dueamt`) AS `Due_Amt` from `co-operativebank-199`.`shg_subsidy_f` `f` join `co-operativebank-199`.`shg_subsidy_f4` `l` where (`l`.`acc_no` = `f`.`acc_no`) group by `l`.`acc_no`
