TYPE=VIEW
query=select `l`.`id` AS `id`,`l`.`acc_no` AS `acc_no`,`l`.`amt` AS `amt`,sum(`ld`.`Total_amt`) AS `bal`,max(`ld`.`com_sts`) AS `com_sts` from (`co-operativebank-242`.`loan_acc` `l` join `co-operativebank-242`.`loan_deposit` `ld`) where (`ld`.`loan_id` = `l`.`id`) group by `ld`.`loan_id`
md5=109694f2711434cf19fbb41e7b839711
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-15 05:24:42
create-version=1
source=select  `l`.`id`  AS  `id` ,\n `l`.`acc_no`  AS  `acc_no` ,\n `l`.`amt`  AS  `amt` ,\nsum(  `ld`.`Total_amt`  )  AS  `bal` ,\nmax(  `ld`.`com_sts`  )  AS  `com_sts`  from (  `co-operativebank-242`.`loan_acc`  `l`  join  `co-operativebank-242`.`loan_deposit`  `ld`  ) where (  `ld`.`loan_id`  =  `l`.`id`  ) group  by  `ld`.`loan_id`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `l`.`id` AS `id`,`l`.`acc_no` AS `acc_no`,`l`.`amt` AS `amt`,sum(`ld`.`Total_amt`) AS `bal`,max(`ld`.`com_sts`) AS `com_sts` from (`co-operativebank-242`.`loan_acc` `l` join `co-operativebank-242`.`loan_deposit` `ld`) where (`ld`.`loan_id` = `l`.`id`) group by `ld`.`loan_id`
