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`.`loan_acc` `la` join `co-operativebank`.`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`.`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=6695296c9526906cae6bac9d604ecb9d
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2016-06-29 07:43:19
create-version=1
source=select la.date_open,la.acc_no,la.amt-sum(total_amt),la.amt from loan_acc la,loan_deposit ld where la.acc_no=ld.acc_no and la.id=ld.loan_id and (select sum(com_sts) from 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`.`loan_acc` `la` join `co-operativebank`.`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`.`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`
