TYPE=VIEW
query=select `lc`.`acc_no` AS `acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name` from `co-operativebank`.`loan_acc` `lc` join `co-operativebank`.`applicant` `a` where (`lc`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `lc`.`acc_no`
md5=4514602f594dfd60844afd9b3e5b5ab9
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2017-10-31 11:09:38
create-version=1
source=select lc.acc_no,concat(a.initial,\' \',a.fname,\' \',a.mname,\' \',a.lname) as Name from loan_acc lc, applicant a where lc.loan_against_sv_acc=a.acc_no group by lc.acc_no
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `lc`.`acc_no` AS `acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name` from `co-operativebank`.`loan_acc` `lc` join `co-operativebank`.`applicant` `a` where (`lc`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `lc`.`acc_no`
