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`.`shares` `s` join `co-operativebank`.`j_a` `a` where (`a`.`Acc_No` = `s`.`acc_no`)
md5=1eec917cebcff6634bd5154eba9a5c71
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2016-11-24 05:47:22
create-version=1
source=SELECT s.code,a.acc_no,concat(a.fname,\' \',a.mname,\' \',a.lname) as Name,a.father_name FROM `shares` s,j_a a WHERE a.acc_no=s.acc_no
client_cs_name=utf8
connection_cl_name=utf8mb4_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`.`shares` `s` join `co-operativebank`.`j_a` `a` where (`a`.`Acc_No` = `s`.`acc_no`)
