TYPE=VIEW
query=select `sh`.`code` AS `Account_Number`,`sh`.`mem_id` AS `Member_Id`,`sh`.`acc_no` AS `Savings_A/C_NO`,`h`.`head` AS `head`,`sh`.`date` AS `Share_Date`,`ac`.`Name` AS `Name`,`ac`.`Father_Name` AS `Father_Name`,`ac`.`Dob` AS `Dob`,`sh`.`oth_amt` AS `Admission_Charge`,`sh`.`amt` AS `Share_ammount`,`sub_h`.`sub_head` AS `Loan_Against`,`shb`.`mesurement` AS `Share_Land_in_Decimal`,`sh`.`karbanama` AS `karbanama`,`sh`.`code` AS `code` from ((((`co-operativebank-bajbajia`.`shares` `sh` join `co-operativebank-bajbajia`.`head` `h`) join `co-operativebank-bajbajia`.`sub_head` `sub_h`) join `co-operativebank-bajbajia`.`share_object` `shb`) join `co-operativebank-bajbajia`.`account` `ac`) where ((`sh`.`code` = `shb`.`code`) and (`sh`.`acc_no` = `ac`.`Acc_no`) and (`sh`.`head` = `h`.`code`) and (`shb`.`sub_head` = `sub_h`.`code`))
md5=8a3726697fbfcfcfe213c8b046f30a0f
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:16
create-version=1
source=select `sh`.`code` AS `Account_Number`,`sh`.`mem_id` AS `Member_Id`,`sh`.`acc_no` AS `Savings_A/C_NO`,`h`.`head` AS `head`,`sh`.`date` AS `Share_Date`,`ac`.`Name` AS `Name`,`ac`.`Father_Name` AS `Father_Name`,`ac`.`Dob` AS `Dob`,`sh`.`oth_amt` AS `Admission_Charge`,`sh`.`amt` AS `Share_ammount`,`sub_h`.`sub_head` AS `Loan_Against`,`shb`.`mesurement` AS `Share_Land_in_Decimal`,`sh`.`karbanama` AS `karbanama`,`sh`.`code` AS `code` from ((((`shares` `sh` join `head` `h`) join `sub_head` `sub_h`) join `share_object` `shb`) join `account` `ac`) where ((`sh`.`code` = `shb`.`code`) and (`sh`.`acc_no` = `ac`.`Acc_no`) and (`sh`.`head` = `h`.`code`) and (`shb`.`sub_head` = `sub_h`.`code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `sh`.`code` AS `Account_Number`,`sh`.`mem_id` AS `Member_Id`,`sh`.`acc_no` AS `Savings_A/C_NO`,`h`.`head` AS `head`,`sh`.`date` AS `Share_Date`,`ac`.`Name` AS `Name`,`ac`.`Father_Name` AS `Father_Name`,`ac`.`Dob` AS `Dob`,`sh`.`oth_amt` AS `Admission_Charge`,`sh`.`amt` AS `Share_ammount`,`sub_h`.`sub_head` AS `Loan_Against`,`shb`.`mesurement` AS `Share_Land_in_Decimal`,`sh`.`karbanama` AS `karbanama`,`sh`.`code` AS `code` from ((((`co-operativebank-bajbajia`.`shares` `sh` join `co-operativebank-bajbajia`.`head` `h`) join `co-operativebank-bajbajia`.`sub_head` `sub_h`) join `co-operativebank-bajbajia`.`share_object` `shb`) join `co-operativebank-bajbajia`.`account` `ac`) where ((`sh`.`code` = `shb`.`code`) and (`sh`.`acc_no` = `ac`.`Acc_no`) and (`sh`.`head` = `h`.`code`) and (`shb`.`sub_head` = `sub_h`.`code`))
