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-bajbajia`.`account` `a` join `co-operativebank-bajbajia`.`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-bajbajia`.`loan_account` `la` join `co-operativebank-bajbajia`.`heads` `sh`) where ((`la`.`loan_against_sv_acc` <> \'\') and (`sh`.`shcode` = `la`.`sub_head`) and (`sh`.`hcode` = `la`.`head`))
md5=2a293599b350882a25b1d58f47d5a050
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:46
create-version=1
source=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 (`account` `a` join `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 (`loan_account` `la` join `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-bajbajia`.`account` `a` join `co-operativebank-bajbajia`.`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-bajbajia`.`loan_account` `la` join `co-operativebank-bajbajia`.`heads` `sh`) where ((`la`.`loan_against_sv_acc` <> \'\') and (`sh`.`shcode` = `la`.`sub_head`) and (`sh`.`hcode` = `la`.`head`))
