TYPE=VIEW
query=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`co-operativebank-bajbajia`.`share_object` `sh` join `co-operativebank-bajbajia`.`account` `de`) join `co-operativebank-bajbajia`.`head` `h`) join `co-operativebank-bajbajia`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
md5=e507e295becdf9d09cae38c9c342929e
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:13
create-version=1
source=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`share_object` `sh` join `account` `de`) join `head` `h`) join `sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`co-operativebank-bajbajia`.`share_object` `sh` join `co-operativebank-bajbajia`.`account` `de`) join `co-operativebank-bajbajia`.`head` `h`) join `co-operativebank-bajbajia`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
