TYPE=VIEW
query=select `dc`.`id` AS `id`,`a`.`code` AS `code`,`dc`.`acc_no` AS `acc_no`,`dc`.`member_id` AS `member_id`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`dc`.`name_p` AS `Name_Of_Person`,`a`.`father_name` AS `father_name`,`a`.`gender` AS `gender`,`a`.`dob` AS `dob`,`a`.`address` AS `address`,`a`.`city` AS `city`,`a`.`state` AS `state`,`a`.`pin` AS `pin`,`a`.`mobile` AS `mobile`,`a`.`pan` AS `pan`,`a`.`adhar` AS `adhar`,`a`.`voter` AS `voter`,`a`.`occupation` AS `occupation`,`a`.`income` AS `income`,`dc`.`acc_type` AS `acc_type`,`dc`.`date_open` AS `date_open`,`dc`.`head` AS `head`,`dc`.`sub_head` AS `sub_head`,`dc`.`scheme` AS `scheme`,`dc`.`duration` AS `duration`,`dc`.`duration_time` AS `duration_time`,`dc`.`fianl_date` AS `fianl_date`,`dc`.`amt` AS `amt`,`dc`.`interest` AS `interest`,`dc`.`inst_amt` AS `inst_amt`,`dc`.`status` AS `status`,`dc`.`c_status` AS `Complete_status`,`dc`.`no_inst` AS `Number_Instalment`,`dc`.`loan_against` AS `loan_against`,`dc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`dc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`verify` AS `verify`,`dc`.`oth_amt` AS `oth_amt`,`dc`.`vch_no` AS `vch_no` from (`co-operativebank-milani`.`j_a` `a` join `co-operativebank-milani`.`loan_acc` `dc`) where (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`)
md5=0bf76f1f8396df78a17a7f773a1a2f2f
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-10-21 04:25:03
create-version=1
source=select  `dc`.`id`  AS  `id` ,\n `a`.`code`  AS  `code` ,\n `dc`.`acc_no`  AS  `acc_no` ,\n `dc`.`member_id`  AS  `member_id` ,\n `a`.`initial`  AS  `initial` ,\n `a`.`fname`  AS  `fname` ,\n `a`.`mname`  AS  `mname` ,\n `a`.`lname`  AS  `lname` ,\nconcat(  `a`.`initial` ,  \' \',  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name` ,\n `dc`.`name_p`  AS  `Name_Of_Person` ,\n `a`.`father_name`  AS  `father_name` ,\n `a`.`gender`  AS  `gender` ,\n `a`.`dob`  AS  `dob` ,\n `a`.`address`  AS  `address` ,\n `a`.`city`  AS  `city` ,\n `a`.`state`  AS  `state` ,\n `a`.`pin`  AS  `pin` ,\n `a`.`mobile`  AS  `mobile` ,\n `a`.`pan`  AS  `pan` ,\n `a`.`adhar`  AS  `adhar` ,\n `a`.`voter`  AS  `voter` ,\n `a`.`occupation`  AS  `occupation` ,\n `a`.`income`  AS  `income` ,\n `dc`.`acc_type`  AS  `acc_type` ,\n `dc`.`date_open`  AS  `date_open` ,\n `dc`.`head`  AS  `head` ,\n `dc`.`sub_head`  AS  `sub_head` ,\n `dc`.`scheme`  AS  `scheme` ,\n `dc`.`duration`  AS  `duration` ,\n `dc`.`duration_time`  AS  `duration_time` ,\n `dc`.`fianl_date`  AS  `fianl_date` ,\n `dc`.`amt`  AS  `amt` ,\n `dc`.`interest`  AS  `interest` ,\n `dc`.`inst_amt`  AS  `inst_amt` ,\n `dc`.`status`  AS  `status` ,\n `dc`.`c_status`  AS  `Complete_status` ,\n `dc`.`no_inst`  AS  `Number_Instalment` ,\n `dc`.`loan_against`  AS  `loan_against` ,\n `dc`.`loan_agianst_acc_no`  AS  `loan_agianst_acc_no` ,\n `dc`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\n `a`.`verify`  AS  `verify` ,\n `dc`.`oth_amt`  AS  `oth_amt` ,\n `dc`.`vch_no`  AS  `vch_no`  from (  `co-operativebank-milani`.`j_a`  `a`  join  `co-operativebank-milani`.`loan_acc`  `dc`  ) where (  `a`.`Acc_No`  =  `dc`.`loan_against_sv_acc`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `dc`.`id` AS `id`,`a`.`code` AS `code`,`dc`.`acc_no` AS `acc_no`,`dc`.`member_id` AS `member_id`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`dc`.`name_p` AS `Name_Of_Person`,`a`.`father_name` AS `father_name`,`a`.`gender` AS `gender`,`a`.`dob` AS `dob`,`a`.`address` AS `address`,`a`.`city` AS `city`,`a`.`state` AS `state`,`a`.`pin` AS `pin`,`a`.`mobile` AS `mobile`,`a`.`pan` AS `pan`,`a`.`adhar` AS `adhar`,`a`.`voter` AS `voter`,`a`.`occupation` AS `occupation`,`a`.`income` AS `income`,`dc`.`acc_type` AS `acc_type`,`dc`.`date_open` AS `date_open`,`dc`.`head` AS `head`,`dc`.`sub_head` AS `sub_head`,`dc`.`scheme` AS `scheme`,`dc`.`duration` AS `duration`,`dc`.`duration_time` AS `duration_time`,`dc`.`fianl_date` AS `fianl_date`,`dc`.`amt` AS `amt`,`dc`.`interest` AS `interest`,`dc`.`inst_amt` AS `inst_amt`,`dc`.`status` AS `status`,`dc`.`c_status` AS `Complete_status`,`dc`.`no_inst` AS `Number_Instalment`,`dc`.`loan_against` AS `loan_against`,`dc`.`loan_agianst_acc_no` AS `loan_agianst_acc_no`,`dc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`verify` AS `verify`,`dc`.`oth_amt` AS `oth_amt`,`dc`.`vch_no` AS `vch_no` from (`co-operativebank-milani`.`j_a` `a` join `co-operativebank-milani`.`loan_acc` `dc`) where (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`)
