TYPE=VIEW
query=select `la`.`date_open` AS `date_open`,`la`.`acc_no` AS `acc_no`,(`la`.`amt` - sum(`ld`.`Total_amt`)) AS `la.amt-sum(total_amt)`,`la`.`amt` AS `amt` from (`co-operativebank-234`.`loan_acc` `la` join `co-operativebank-234`.`loan_deposit` `ld`) where ((`la`.`acc_no` = `ld`.`Acc_No`) and (`la`.`id` = `ld`.`loan_id`) and ((select sum(`ld1`.`com_sts`) from `co-operativebank-234`.`loan_deposit` `ld1` where ((`ld1`.`Acc_No` = `la`.`acc_no`) and (`la`.`date_open` <= `ld`.`Date`))) = 0) and (`la`.`date_open` >= `ld`.`Date`)) group by `la`.`acc_no`
md5=7a722c7983f01abd7e93b0d2915c23ef
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-08-01 11:04:15
create-version=1
source=select  `la`.`date_open`  AS  `date_open` ,\n `la`.`acc_no`  AS  `acc_no` ,\n(  `la`.`amt`  - sum(  `ld`.`Total_amt`  )  ) AS  `la.amt-sum(total_amt)` ,\n `la`.`amt`  AS  `amt`  from (  `co-operativebank-234`.`loan_acc`  `la`  join  `co-operativebank-234`.`loan_deposit`  `ld`  ) where ( (  `la`.`acc_no`  =  `ld`.`Acc_No`  ) and (  `la`.`id`  =  `ld`.`loan_id`  ) and ( (  select sum(  `ld1`.`com_sts`  )  from  `co-operativebank-234`.`loan_deposit`  `ld1`  where ( (  `ld1`.`Acc_No`  =  `la`.`acc_no`  ) and (  `la`.`date_open`  <=  `ld`.`Date`  ) ) ) =0 ) and (  `la`.`date_open`  >=  `ld`.`Date`  ) ) group  by  `la`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `la`.`date_open` AS `date_open`,`la`.`acc_no` AS `acc_no`,(`la`.`amt` - sum(`ld`.`Total_amt`)) AS `la.amt-sum(total_amt)`,`la`.`amt` AS `amt` from (`co-operativebank-234`.`loan_acc` `la` join `co-operativebank-234`.`loan_deposit` `ld`) where ((`la`.`acc_no` = `ld`.`Acc_No`) and (`la`.`id` = `ld`.`loan_id`) and ((select sum(`ld1`.`com_sts`) from `co-operativebank-234`.`loan_deposit` `ld1` where ((`ld1`.`Acc_No` = `la`.`acc_no`) and (`la`.`date_open` <= `ld`.`Date`))) = 0) and (`la`.`date_open` >= `ld`.`Date`)) group by `la`.`acc_no`
