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-dekhaliannapurna`.`shares` `sh` join `co-operativebank-dekhaliannapurna`.`head` `h`) join `co-operativebank-dekhaliannapurna`.`sub_head` `sub_h`) join `co-operativebank-dekhaliannapurna`.`share_object` `shb`) join `co-operativebank-dekhaliannapurna`.`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=eb8efdd617e3391a19f652f9f0db5042
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-05-24 07:43:45
create-version=1
source=select  `sh`.`code`  AS  `Account_Number` ,\n `sh`.`mem_id`  AS  `Member_Id` ,\n `sh`.`acc_no`  AS  `Savings_A/C_NO` ,\n `h`.`head`  AS  `head` ,\n `sh`.`date`  AS  `Share_Date` ,\n `ac`.`Name`  AS  `Name` ,\n `ac`.`Father_Name`  AS  `Father_Name` ,\n `ac`.`Dob`  AS  `Dob` ,\n `sh`.`oth_amt`  AS  `Admission_Charge` ,\n `sh`.`amt`  AS  `Share_ammount` ,\n `sub_h`.`sub_head`  AS  `Loan_Against` ,\n `shb`.`mesurement`  AS  `Share_Land_in_Decimal` ,\n `sh`.`karbanama`  AS  `karbanama` ,\n `sh`.`code`  AS  `code`  from ( ( ( (  `co-operativebank-dekhaliannapurna`.`shares`  `sh`  join  `co-operativebank-dekhaliannapurna`.`head`  `h`  ) join  `co-operativebank-dekhaliannapurna`.`sub_head`  `sub_h`  ) join  `co-operativebank-dekhaliannapurna`.`share_object`  `shb`  ) join  `co-operativebank-dekhaliannapurna`.`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-dekhaliannapurna`.`shares` `sh` join `co-operativebank-dekhaliannapurna`.`head` `h`) join `co-operativebank-dekhaliannapurna`.`sub_head` `sub_h`) join `co-operativebank-dekhaliannapurna`.`share_object` `shb`) join `co-operativebank-dekhaliannapurna`.`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`))
