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`.`j_a` `a` join `co-operativebank`.`loan_acc` `dc`) where (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`)
md5=cf77451196daf1497d5eb39c779b9be1
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2018-05-19 04:11:13
create-version=1
source=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 (`j_a` `a` join `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`.`j_a` `a` join `co-operativebank`.`loan_acc` `dc`) where (`a`.`Acc_No` = `dc`.`loan_against_sv_acc`)
