TYPE=VIEW
query=select `co-operativebank`.`deposit_acc`.`acc_no` AS `acc_no`,`a`.`Name` AS `name`,`a`.`Father_Name` AS `father_name`,`a`.`Address` AS `address`,`co-operativebank`.`deposit_acc`.`acc_type` AS `acc_type`,`co-operativebank`.`deposit_acc`.`date_open` AS `date_open`,`sh`.`sub_head` AS `sub_head`,`co-operativebank`.`deposit_acc`.`Deposit_Type` AS `Deposit_Type`,`co-operativebank`.`deposit_acc`.`amt` AS `amt`,`co-operativebank`.`deposit_acc`.`maturity_amt` AS `maturity_amt`,`co-operativebank`.`deposit_acc`.`maturity_date` AS `maturity_date`,`co-operativebank`.`deposit_acc`.`interest` AS `interest`,`co-operativebank`.`deposit_acc`.`Duration` AS `Duration`,`co-operativebank`.`deposit_acc`.`Duration_Type` AS `Duration_Type`,`co-operativebank`.`deposit_acc`.`sub_head` AS `sub_head1`,`co-operativebank`.`deposit_acc`.`status` AS `status`,`co-operativebank`.`deposit_acc`.`operation_type` AS `operation_type`,`n`.`name` AS `nominee_name`,`n`.`relation` AS `relation`,`a`.`lf_no` AS `lf_no`,`a`.`Pan` AS `PAN`,`a`.`Adhar` AS `ADHAR`,`a`.`Mobile` AS `MOBILE` from (((`co-operativebank`.`deposit_acc` join `co-operativebank`.`sub_head` `sh`) join `co-operativebank`.`account` `a`) join `co-operativebank`.`nominee` `n`) where ((`n`.`acc_no` = `co-operativebank`.`deposit_acc`.`acc_no`) and (`n`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank`.`deposit_acc`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank`.`deposit_acc`.`sub_head` = `sh`.`code`))
md5=22fe6b883c4c2287ac4724f05c925dcb
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-07-14 14:30:14
create-version=1
source=select `deposit_acc`.`acc_no` AS `acc_no`,`a`.`Name` AS `name`,`a`.`Father_Name` AS `father_name`,`a`.`Address` AS `address`,`deposit_acc`.`acc_type` AS `acc_type`,`deposit_acc`.`date_open` AS `date_open`,`sh`.`sub_head` AS `sub_head`,`deposit_acc`.`Deposit_Type` AS `Deposit_Type`,`deposit_acc`.`amt` AS `amt`,`deposit_acc`.`maturity_amt` AS `maturity_amt`,`deposit_acc`.`maturity_date` AS `maturity_date`,`deposit_acc`.`interest` AS `interest`,`deposit_acc`.`Duration` AS `Duration`,`deposit_acc`.`Duration_Type` AS `Duration_Type`,`deposit_acc`.`sub_head` AS `sub_head1`,`deposit_acc`.`status` AS `status`,`deposit_acc`.`operation_type` AS `operation_type`,`n`.`name` AS `nominee_name`,`n`.`relation` AS `relation`,`a`.`lf_no` AS `lf_no`,PAN,ADHAR,MOBILE from (((`deposit_acc` join `sub_head` `sh`) join `account` `a`) join `nominee` `n`) where ((`n`.`acc_no` = `deposit_acc`.`acc_no`) and (`n`.`acc_no` = `a`.`Acc_no`) and (`deposit_acc`.`acc_no` = `a`.`Acc_no`) and (`deposit_acc`.`sub_head` = `sh`.`code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`deposit_acc`.`acc_no` AS `acc_no`,`a`.`Name` AS `name`,`a`.`Father_Name` AS `father_name`,`a`.`Address` AS `address`,`co-operativebank`.`deposit_acc`.`acc_type` AS `acc_type`,`co-operativebank`.`deposit_acc`.`date_open` AS `date_open`,`sh`.`sub_head` AS `sub_head`,`co-operativebank`.`deposit_acc`.`Deposit_Type` AS `Deposit_Type`,`co-operativebank`.`deposit_acc`.`amt` AS `amt`,`co-operativebank`.`deposit_acc`.`maturity_amt` AS `maturity_amt`,`co-operativebank`.`deposit_acc`.`maturity_date` AS `maturity_date`,`co-operativebank`.`deposit_acc`.`interest` AS `interest`,`co-operativebank`.`deposit_acc`.`Duration` AS `Duration`,`co-operativebank`.`deposit_acc`.`Duration_Type` AS `Duration_Type`,`co-operativebank`.`deposit_acc`.`sub_head` AS `sub_head1`,`co-operativebank`.`deposit_acc`.`status` AS `status`,`co-operativebank`.`deposit_acc`.`operation_type` AS `operation_type`,`n`.`name` AS `nominee_name`,`n`.`relation` AS `relation`,`a`.`lf_no` AS `lf_no`,`a`.`Pan` AS `PAN`,`a`.`Adhar` AS `ADHAR`,`a`.`Mobile` AS `MOBILE` from (((`co-operativebank`.`deposit_acc` join `co-operativebank`.`sub_head` `sh`) join `co-operativebank`.`account` `a`) join `co-operativebank`.`nominee` `n`) where ((`n`.`acc_no` = `co-operativebank`.`deposit_acc`.`acc_no`) and (`n`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank`.`deposit_acc`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank`.`deposit_acc`.`sub_head` = `sh`.`code`))
