TYPE=VIEW
query=select `a`.`lf_no` AS `lf_no`,`v`.`date` AS `Open_date`,`v`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`a`.`interest` AS `interest`,max(`v`.`date`) AS `pay_date` from (`co-operativebank-milani`.`voucher` `v` join `co-operativebank-milani`.`account` `a`) where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2021-05-15\')) group by `v`.`Acc_no`
md5=0284dfb1a3ec78b8c5d8965ab88eb77d
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-10-21 04:25:04
create-version=1
source=select  `a`.`lf_no`  AS  `lf_no` ,\n `v`.`date`  AS  `Open_date` ,\n `v`.`Acc_no`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n( sum(  `v`.`cr`  )  - sum(  `v`.`dr`  )  ) AS  `bal` ,\n `a`.`interest`  AS  `interest` ,\nmax(  `v`.`date`  )  AS  `pay_date`  from (  `co-operativebank-milani`.`voucher`  `v`  join  `co-operativebank-milani`.`account`  `a`  ) where ( (  `a`.`Sub_Head`  =  \'14107\' ) and (  `a`.`Acc_no`  =  `v`.`Acc_no`  ) and (  `v`.`date`  <=  \'2021-05-15\' ) ) group  by  `v`.`Acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`lf_no` AS `lf_no`,`v`.`date` AS `Open_date`,`v`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `bal`,`a`.`interest` AS `interest`,max(`v`.`date`) AS `pay_date` from (`co-operativebank-milani`.`voucher` `v` join `co-operativebank-milani`.`account` `a`) where ((`a`.`Sub_Head` = \'14107\') and (`a`.`Acc_no` = `v`.`Acc_no`) and (`v`.`date` <= \'2021-05-15\')) group by `v`.`Acc_no`
