TYPE=VIEW
query=select `l`.`acc_no` AS `acc_no`,sum(`n`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from `co-operativebank-201`.`nsc_detail` `n` join `co-operativebank-201`.`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-201`.`loan_acc` `l` join `co-operativebank-201`.`deposit_acc` `d` where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
md5=ad77d837fe32cc4e32aa9814feacd3b3
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-08-21 04:53:09
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=utf8
connection_cl_name=utf8_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-201`.`nsc_detail` `n` join `co-operativebank-201`.`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-201`.`loan_acc` `l` join `co-operativebank-201`.`deposit_acc` `d` where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
