TYPE=VIEW
query=select `s`.`code` AS `code`,`a`.`Acc_No` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `father_name` from (`co-operativebank-244`.`shares` `s` join `co-operativebank-244`.`j_a` `a`) where (`a`.`Acc_No` = `s`.`acc_no`)
md5=4863a5811a4284fd5f90e8e0c61bbbb3
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-19 04:30:21
create-version=1
source=select  `s`.`code`  AS  `code` ,\n `a`.`Acc_No`  AS  `acc_no` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `Name` ,\n `a`.`father_name`  AS  `father_name`  from (  `co-operativebank-244`.`shares`  `s`  join  `co-operativebank-244`.`j_a`  `a`  ) where (  `a`.`Acc_No`  =  `s`.`acc_no`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `s`.`code` AS `code`,`a`.`Acc_No` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `father_name` from (`co-operativebank-244`.`shares` `s` join `co-operativebank-244`.`j_a` `a`) where (`a`.`Acc_No` = `s`.`acc_no`)
