TYPE=VIEW
query=select concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`address` AS `address`,`a`.`adhar` AS `adhar`,`a`.`pan` AS `pan` from `co-operativebank-dekhaliannapurna`.`applicant` `a` join `co-operativebank-dekhaliannapurna`.`deposit_acc` `d` where ((`d`.`acc_no` = `a`.`Acc_No`) and (`d`.`acc_type` = \'sv\') and (`a`.`mobile` <> \'\')) group by `a`.`Acc_No`
md5=db919c19b16fe742826261fed6a89b3b
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-11-26 07:09:10
create-version=1
source=SELECT concat(initial,\' \',fname,\' \',mname,\' \',lname) as name,mobile,email,address,adhar,pan FROM `applicant` a, deposit_acc d where d.acc_no=a.acc_no and acc_type=\'sv\' and mobile<>\'\' group by a.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`address` AS `address`,`a`.`adhar` AS `adhar`,`a`.`pan` AS `pan` from `co-operativebank-dekhaliannapurna`.`applicant` `a` join `co-operativebank-dekhaliannapurna`.`deposit_acc` `d` where ((`d`.`acc_no` = `a`.`Acc_No`) and (`d`.`acc_type` = \'sv\') and (`a`.`mobile` <> \'\')) group by `a`.`Acc_No`
