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`.`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`.`applicant` `a` join `co-operativebank`.`shares` `s` where (`s`.`acc_no` = `a`.`Acc_No`) order by `acc_no`
md5=87885cb576e4c38b948b4ced5fc6265c
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2019-07-10 15:20:15
create-version=1
source=select a.acc_no,initial,`fname`,`mname`,`lname`,Father_name from applicant a  union all select s.code as acc_no,a.initial,a.`fname`,a.`mname`,a.`lname`,a.Father_name from applicant a,shares s where s.acc_no=a.acc_no
\nORDER BY `acc_no` ASC
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`.`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`.`applicant` `a` join `co-operativebank`.`shares` `s` where (`s`.`acc_no` = `a`.`Acc_No`) order by `acc_no`
