TYPE=VIEW
query=select `s`.`date_open` AS `date_open`,`s`.`acc_no` AS `acc_no`,`s`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`s`.`name` AS `name`,`s`.`amt` AS `amt`,`s`.`interest` AS `interest`,`s1`.`int_amt` AS `int_amt`,`s1`.`max_dt` AS `max_dt`,`s1`.`subsidy` AS `subsidy`,`s1`.`Due_Amt` AS `Due_Amt`,`s`.`sblfno` AS `sblfno`,`s`.`llfno` AS `llfno`,`s`.`father_name` AS `father_name`,`s`.`address` AS `address`,`s`.`bankacc` AS `bankacc`,`s`.`mobile` AS `mobile`,`s`.`adhar` AS `adhar`,`s`.`status` AS `status`,`s`.`pan` AS `pan`,`s`.`voter` AS `voter`,`s`.`cust` AS `cust`,`s`.`gender` AS `gender`,`s`.`dob` AS `dob`,`s`.`block` AS `block` from (`co-operativebank-198`.`subidy` `s` join `co-operativebank-198`.`subidy1` `s1`) where ((`s`.`id` = `s1`.`loan_id`) and (`s`.`amt` = `s1`.`prince`)) order by `s1`.`acc_no`
md5=04b9658ef601c170b7dee17edf6e2b05
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:45
create-version=1
source=select  `s`.`date_open`  AS  `date_open` ,\n `s`.`acc_no`  AS  `acc_no` ,\n `s`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\n `s`.`name`  AS  `name` ,\n `s`.`amt`  AS  `amt` ,\n `s`.`interest`  AS  `interest` ,\n `s1`.`int_amt`  AS  `int_amt` ,\n `s1`.`max_dt`  AS  `max_dt` ,\n `s1`.`subsidy`  AS  `subsidy` ,\n `s1`.`Due_Amt`  AS  `Due_Amt` ,\n `s`.`sblfno`  AS  `sblfno` ,\n `s`.`llfno`  AS  `llfno` ,\n `s`.`father_name`  AS  `father_name` ,\n `s`.`address`  AS  `address` ,\n `s`.`bankacc`  AS  `bankacc` ,\n `s`.`mobile`  AS  `mobile` ,\n `s`.`adhar`  AS  `adhar` ,\n `s`.`status`  AS  `status` ,\n `s`.`pan`  AS  `pan` ,\n `s`.`voter`  AS  `voter` ,\n `s`.`cust`  AS  `cust` ,\n `s`.`gender`  AS  `gender` ,\n `s`.`dob`  AS  `dob` ,\n `s`.`block`  AS  `block`  from (  `co-operativebank-198`.`subidy`  `s`  join  `co-operativebank-198`.`subidy1`  `s1`  ) where ( (  `s`.`id`  =  `s1`.`loan_id`  ) and (  `s`.`amt`  =  `s1`.`prince`  ) ) order  by  `s1`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `s`.`date_open` AS `date_open`,`s`.`acc_no` AS `acc_no`,`s`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`s`.`name` AS `name`,`s`.`amt` AS `amt`,`s`.`interest` AS `interest`,`s1`.`int_amt` AS `int_amt`,`s1`.`max_dt` AS `max_dt`,`s1`.`subsidy` AS `subsidy`,`s1`.`Due_Amt` AS `Due_Amt`,`s`.`sblfno` AS `sblfno`,`s`.`llfno` AS `llfno`,`s`.`father_name` AS `father_name`,`s`.`address` AS `address`,`s`.`bankacc` AS `bankacc`,`s`.`mobile` AS `mobile`,`s`.`adhar` AS `adhar`,`s`.`status` AS `status`,`s`.`pan` AS `pan`,`s`.`voter` AS `voter`,`s`.`cust` AS `cust`,`s`.`gender` AS `gender`,`s`.`dob` AS `dob`,`s`.`block` AS `block` from (`co-operativebank-198`.`subidy` `s` join `co-operativebank-198`.`subidy1` `s1`) where ((`s`.`id` = `s1`.`loan_id`) and (`s`.`amt` = `s1`.`prince`)) order by `s1`.`acc_no`
