TYPE=VIEW
query=select `l`.`acc_no` AS `acc_no`,sum(`n`.`amt`) AS `amt`,`l`.`sub_head` AS `sub_head` from (`co-operativebank-242`.`nsc_detail` `n` join `co-operativebank-242`.`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-242`.`loan_acc` `l` join `co-operativebank-242`.`deposit_acc` `d`) where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
md5=ec49dd895aa4ba06160566faa5237883
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-15 05:24:43
create-version=1
source=select  `l`.`acc_no`  AS  `acc_no` ,\nsum(  `n`.`amt`  )  AS  `amt` ,\n `l`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-242`.`nsc_detail`  `n`  join  `co-operativebank-242`.`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` ,\nsum(  `d`.`amt`  )  AS  `amt` ,\n `l`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-242`.`loan_acc`  `l`  join  `co-operativebank-242`.`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-242`.`nsc_detail` `n` join `co-operativebank-242`.`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-242`.`loan_acc` `l` join `co-operativebank-242`.`deposit_acc` `d`) where ((`l`.`acc_no` = `d`.`loan_acc_no`) and (`l`.`sub_head` = \'23115\')) group by `l`.`acc_no`
