TYPE=VIEW
query=select `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no` AS `acc_no`,`a`.`Name` AS `name`,`a`.`Father_Name` AS `father_name`,`a`.`Address` AS `address`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_type` AS `acc_type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`date_open` AS `date_open`,`sh`.`sub_head` AS `sub_head`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Deposit_Type` AS `Deposit_Type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`amt` AS `amt`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_amt` AS `maturity_amt`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_date` AS `maturity_date`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`interest` AS `interest`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration` AS `Duration`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration_Type` AS `Duration_Type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head` AS `sub_head1`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`status` AS `status`,`co-operativebank-dekhaliannapurna`.`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-dekhaliannapurna`.`deposit_acc` join `co-operativebank-dekhaliannapurna`.`sub_head` `sh`) join `co-operativebank-dekhaliannapurna`.`account` `a`) join `co-operativebank-dekhaliannapurna`.`nominee` `n`) where ((`n`.`acc_no` = `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no`) and (`n`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head` = `sh`.`code`))
md5=b47788ec46943fc90dbda7a8cad58d0a
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-05-24 07:43:29
create-version=1
source=select  `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n `a`.`Father_Name`  AS  `father_name` ,\n `a`.`Address`  AS  `address` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_type`  AS  `acc_type` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`date_open`  AS  `date_open` ,\n `sh`.`sub_head`  AS  `sub_head` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`Deposit_Type`  AS  `Deposit_Type` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`amt`  AS  `amt` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_amt`  AS  `maturity_amt` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_date`  AS  `maturity_date` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`interest`  AS  `interest` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration`  AS  `Duration` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration_Type`  AS  `Duration_Type` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head`  AS  `sub_head1` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`status`  AS  `status` ,\n `co-operativebank-dekhaliannapurna`.`deposit_acc`.`operation_type`  AS  `operation_type` ,\n `n`.`name`  AS  `nominee_name` ,\n `n`.`relation`  AS  `relation` ,\n `a`.`lf_no`  AS  `lf_no` ,\n `a`.`Pan`  AS  `PAN` ,\n `a`.`Adhar`  AS  `ADHAR` ,\n `a`.`Mobile`  AS  `MOBILE`  from ( ( (  `co-operativebank-dekhaliannapurna`.`deposit_acc`  join  `co-operativebank-dekhaliannapurna`.`sub_head`  `sh`  ) join  `co-operativebank-dekhaliannapurna`.`account`  `a`  ) join  `co-operativebank-dekhaliannapurna`.`nominee`  `n`  ) where ( (  `n`.`acc_no`  =  `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no`  ) and (  `n`.`acc_no`  =  `a`.`Acc_no`  ) and (  `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no`  =  `a`.`Acc_no`  ) and (  `co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head`  =  `sh`.`code`  ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no` AS `acc_no`,`a`.`Name` AS `name`,`a`.`Father_Name` AS `father_name`,`a`.`Address` AS `address`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_type` AS `acc_type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`date_open` AS `date_open`,`sh`.`sub_head` AS `sub_head`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Deposit_Type` AS `Deposit_Type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`amt` AS `amt`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_amt` AS `maturity_amt`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`maturity_date` AS `maturity_date`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`interest` AS `interest`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration` AS `Duration`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`Duration_Type` AS `Duration_Type`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head` AS `sub_head1`,`co-operativebank-dekhaliannapurna`.`deposit_acc`.`status` AS `status`,`co-operativebank-dekhaliannapurna`.`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-dekhaliannapurna`.`deposit_acc` join `co-operativebank-dekhaliannapurna`.`sub_head` `sh`) join `co-operativebank-dekhaliannapurna`.`account` `a`) join `co-operativebank-dekhaliannapurna`.`nominee` `n`) where ((`n`.`acc_no` = `co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no`) and (`n`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`deposit_acc`.`acc_no` = `a`.`Acc_no`) and (`co-operativebank-dekhaliannapurna`.`deposit_acc`.`sub_head` = `sh`.`code`))
