TYPE=VIEW
query=select `a`.`Acc_No` AS `acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `Father_name` from `co-operativebank-henria`.`applicant` `a` union all select `s`.`code` AS `acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `Father_name` from (`co-operativebank-henria`.`applicant` `a` join `co-operativebank-henria`.`shares` `s`) where (`s`.`acc_no` = `a`.`Acc_No`) order by `acc_no`
md5=21cb8bff5efa83879647181df2ff2ed4
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-15 17:07:06
create-version=1
source=select  `a`.`Acc_No`  AS  `acc_no` ,\n `a`.`initial`  AS  `initial` ,\n `a`.`fname`  AS  `fname` ,\n `a`.`mname`  AS  `mname` ,\n `a`.`lname`  AS  `lname` ,\n `a`.`father_name`  AS  `Father_name`  from  `co-operativebank-henria`.`applicant`  `a`  union  all  select  `s`.`code`  AS  `acc_no` ,\n `a`.`initial`  AS  `initial` ,\n `a`.`fname`  AS  `fname` ,\n `a`.`mname`  AS  `mname` ,\n `a`.`lname`  AS  `lname` ,\n `a`.`father_name`  AS  `Father_name`  from (  `co-operativebank-henria`.`applicant`  `a`  join  `co-operativebank-henria`.`shares`  `s`  ) where (  `s`.`acc_no`  =  `a`.`Acc_No`  ) order  by  `acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`Acc_No` AS `acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `Father_name` from `co-operativebank-henria`.`applicant` `a` union all select `s`.`code` AS `acc_no`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `Father_name` from (`co-operativebank-henria`.`applicant` `a` join `co-operativebank-henria`.`shares` `s`) where (`s`.`acc_no` = `a`.`Acc_No`) order by `acc_no`
