TYPE=VIEW
query=select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`fd_sv_acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `l`.`code` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from `co-operativebank`.`income` `l` join `co-operativebank`.`applicant` `a` where ((`a`.`Acc_No` = `l`.`code`) and (`l`.`shlip_no` like \'SV-D%\')) group by `l`.`code` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`loan_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `d`.`acc_no` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`mstr_bnk_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`shares` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank`.`income` `i` join `co-operativebank`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\')) union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank`.`libities` `i` join `co-operativebank`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))
md5=ed637fcede3a42e26345bfe790d1c87d
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2018-05-19 04:42:53
create-version=1
source=select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`deposit_acc` `d` join `applicant` `a`) where (`d`.`fd_sv_acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all SELECT l.code as acc_no,concat(a.fname,\' \',a.mname,\' \',a.lname) as name  FROM `income` l, applicant a WHERE a.acc_no=l.code and l.shlip_no LIKE \'SV-D%\' group by l.code union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`loan_acc` `d` join `applicant` `a`) where (`d`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `d`.`acc_no` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`mstr_bnk_acc` `d` join `applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`shares` `d` join `applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`income` `i` join `sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\')) union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`libities` `i` join `sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`deposit_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`fd_sv_acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `l`.`code` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from `co-operativebank`.`income` `l` join `co-operativebank`.`applicant` `a` where ((`a`.`Acc_No` = `l`.`code`) and (`l`.`shlip_no` like \'SV-D%\')) group by `l`.`code` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`loan_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `d`.`acc_no` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`mstr_bnk_acc` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank`.`shares` `d` join `co-operativebank`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank`.`income` `i` join `co-operativebank`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\')) union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank`.`libities` `i` join `co-operativebank`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))
