TYPE=VIEW
query=select `a`.`Acc_no` AS `Acc_No`,`a`.`Sv_Acc_no` AS `Sv_Acc_no`,`a`.`Name` AS `Name`,`a`.`Father_Name` AS `father_name`,`a`.`Date_open` AS `date_open`,`a`.`Acc_Type` AS `acc_type`,`sh`.`head` AS `head`,`sh`.`sub_head` AS `sub_head`,`a`.`amt` AS `Principle_ammount`,`a`.`Status` AS `Status`,`a`.`loan_acc_no` AS `Loan_agenst` from (`co-operativebank-durgapur`.`account` `a` join `co-operativebank-durgapur`.`heads` `sh`) where ((`a`.`Sv_Acc_no` <> \'\') and (`sh`.`shcode` = `a`.`Sub_Head`) and (`sh`.`hcode` = `a`.`Head`)) union all select `la`.`acc_no` AS `Acc_No`,`la`.`loan_against_sv_acc` AS `Sv_Acc_no`,`la`.`name` AS `Name`,`la`.`father_name` AS `father_name`,`la`.`date_open` AS `date_open`,`la`.`acc_type` AS `acc_type`,`sh`.`head` AS `head`,`sh`.`sub_head` AS `sub_head`,`la`.`amt` AS `Principle_ammount`,`la`.`status` AS `Status`,`la`.`loan_agianst_acc_no` AS `Loan_agenst` from (`co-operativebank-durgapur`.`loan_account` `la` join `co-operativebank-durgapur`.`heads` `sh`) where ((`la`.`loan_against_sv_acc` <> \'\') and (`sh`.`shcode` = `la`.`sub_head`) and (`sh`.`hcode` = `la`.`head`))
md5=96d8febac3f53dcaa0170e49a20142df
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-04-04 10:26:48
create-version=1
source=select  `a`.`Acc_no`  AS  `Acc_No` ,\n `a`.`Sv_Acc_no`  AS  `Sv_Acc_no` ,\n `a`.`Name`  AS  `Name` ,\n `a`.`Father_Name`  AS  `father_name` ,\n `a`.`Date_open`  AS  `date_open` ,\n `a`.`Acc_Type`  AS  `acc_type` ,\n `sh`.`head`  AS  `head` ,\n `sh`.`sub_head`  AS  `sub_head` ,\n `a`.`amt`  AS  `Principle_ammount` ,\n `a`.`Status`  AS  `Status` ,\n `a`.`loan_acc_no`  AS  `Loan_agenst`  from (  `co-operativebank-durgapur`.`account`  `a`  join  `co-operativebank-durgapur`.`heads`  `sh`  ) where ( (  `a`.`Sv_Acc_no`  <>  \'\' ) and (  `sh`.`shcode`  =  `a`.`Sub_Head`  ) and (  `sh`.`hcode`  =  `a`.`Head`  ) ) union  all  select  `la`.`acc_no`  AS  `Acc_No` ,\n `la`.`loan_against_sv_acc`  AS  `Sv_Acc_no` ,\n `la`.`name`  AS  `Name` ,\n `la`.`father_name`  AS  `father_name` ,\n `la`.`date_open`  AS  `date_open` ,\n `la`.`acc_type`  AS  `acc_type` ,\n `sh`.`head`  AS  `head` ,\n `sh`.`sub_head`  AS  `sub_head` ,\n `la`.`amt`  AS  `Principle_ammount` ,\n `la`.`status`  AS  `Status` ,\n `la`.`loan_agianst_acc_no`  AS  `Loan_agenst`  from (  `co-operativebank-durgapur`.`loan_account`  `la`  join  `co-operativebank-durgapur`.`heads`  `sh`  ) where ( (  `la`.`loan_against_sv_acc`  <>  \'\' ) and (  `sh`.`shcode`  =  `la`.`sub_head`  ) and (  `sh`.`hcode`  =  `la`.`head`  ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`Acc_no` AS `Acc_No`,`a`.`Sv_Acc_no` AS `Sv_Acc_no`,`a`.`Name` AS `Name`,`a`.`Father_Name` AS `father_name`,`a`.`Date_open` AS `date_open`,`a`.`Acc_Type` AS `acc_type`,`sh`.`head` AS `head`,`sh`.`sub_head` AS `sub_head`,`a`.`amt` AS `Principle_ammount`,`a`.`Status` AS `Status`,`a`.`loan_acc_no` AS `Loan_agenst` from (`co-operativebank-durgapur`.`account` `a` join `co-operativebank-durgapur`.`heads` `sh`) where ((`a`.`Sv_Acc_no` <> \'\') and (`sh`.`shcode` = `a`.`Sub_Head`) and (`sh`.`hcode` = `a`.`Head`)) union all select `la`.`acc_no` AS `Acc_No`,`la`.`loan_against_sv_acc` AS `Sv_Acc_no`,`la`.`name` AS `Name`,`la`.`father_name` AS `father_name`,`la`.`date_open` AS `date_open`,`la`.`acc_type` AS `acc_type`,`sh`.`head` AS `head`,`sh`.`sub_head` AS `sub_head`,`la`.`amt` AS `Principle_ammount`,`la`.`status` AS `Status`,`la`.`loan_agianst_acc_no` AS `Loan_agenst` from (`co-operativebank-durgapur`.`loan_account` `la` join `co-operativebank-durgapur`.`heads` `sh`) where ((`la`.`loan_against_sv_acc` <> \'\') and (`sh`.`shcode` = `la`.`sub_head`) and (`sh`.`hcode` = `la`.`head`))
