TYPE=VIEW
query=select `l`.`acc_no` AS `acc_no`,sum(`n`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from `co-operativebank-durgapur`.`nsc_detail` `n` join `co-operativebank-durgapur`.`loan_acc` `l` where ((`l`.`acc_no` = `n`.`acc_no`) and (`l`.`sub_head` = \'23109\')) group by `n`.`acc_no` union all select `l`.`acc_no` AS `acc_no`,sum(`d`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from `co-operativebank-durgapur`.`loan_acc` `l` join `co-operativebank-durgapur`.`deposit_acc` `d` where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
md5=37201872a05c62553a5db53b114154d9
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-09-06 04:52:15
create-version=1
source=SELECT l.acc_no,sum(n.amt) as amt,l.sub_head FROM `nsc_detail` n, loan_acc l WHERE l.acc_no=n.acc_no and l.sub_head=\'23109\' group by n.acc_no
\n union all SELECT l.acc_no,sum(d.amt) as amt,l.sub_head FROM `loan_acc` l, deposit_acc d WHERE l.acc_no=d.loan_acc_no and l.sub_head=\'23115\' group by l.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `l`.`acc_no` AS `acc_no`,sum(`n`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from `co-operativebank-durgapur`.`nsc_detail` `n` join `co-operativebank-durgapur`.`loan_acc` `l` where ((`l`.`acc_no` = `n`.`acc_no`) and (`l`.`sub_head` = \'23109\')) group by `n`.`acc_no` union all select `l`.`acc_no` AS `acc_no`,sum(`d`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from `co-operativebank-durgapur`.`loan_acc` `l` join `co-operativebank-durgapur`.`deposit_acc` `d` where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
