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`.`shares` `sh` join `co-operativebank`.`head` `h`) join `co-operativebank`.`sub_head` `sub_h`) join `co-operativebank`.`share_object` `shb`) join `co-operativebank`.`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=e5b72d71156d30ac4c568d9b386212e9
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:57
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`.`shares` `sh` join `co-operativebank`.`head` `h`) join `co-operativebank`.`sub_head` `sub_h`) join `co-operativebank`.`share_object` `shb`) join `co-operativebank`.`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`))
