TYPE=VIEW
query=select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,`dc`.`spno` AS `spno` from `co-operativebank-242`.`applicant` join `co-operativebank-242`.`deposit_acc` `dc` where (`dc`.`acc_no` = `co-operativebank-242`.`applicant`.`Acc_No`) group by `co-operativebank-242`.`applicant`.`Acc_No`
md5=29e7ea9ba2d8731b075415182fd951b5
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-19 15:21:46
create-version=1
source=select `applicant`.`no` AS `no`,`applicant`.`code` AS `code`,`applicant`.`initial` AS `initial`,`applicant`.`fname` AS `fname`,`applicant`.`mname` AS `mname`,`applicant`.`lname` AS `lname`,`applicant`.`father_name` AS `father_name`,`applicant`.`gender` AS `gender`,`applicant`.`dob` AS `dob`,`applicant`.`address` AS `address`,`applicant`.`city` AS `city`,`applicant`.`state` AS `state`,`applicant`.`pin` AS `pin`,`applicant`.`mobile` AS `mobile`,`applicant`.`pan` AS `pan`,`applicant`.`adhar` AS `adhar`,`applicant`.`voter` AS `voter`,`applicant`.`occupation` AS `occupation`,`applicant`.`income` AS `income`,`applicant`.`verify` AS `verify`,`applicant`.`Acc_No` AS `Acc_No`,spno from `applicant`,deposit_acc dc where dc.acc_no=applicant.acc_no group by `applicant`.`Acc_No`
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,`dc`.`spno` AS `spno` from `co-operativebank-242`.`applicant` join `co-operativebank-242`.`deposit_acc` `dc` where (`dc`.`acc_no` = `co-operativebank-242`.`applicant`.`Acc_No`) group by `co-operativebank-242`.`applicant`.`Acc_No`
