TYPE=VIEW
query=select `co-operativebank-244`.`applicant`.`no` AS `no`,`co-operativebank-244`.`applicant`.`code` AS `code`,`co-operativebank-244`.`applicant`.`initial` AS `initial`,`co-operativebank-244`.`applicant`.`fname` AS `fname`,`co-operativebank-244`.`applicant`.`mname` AS `mname`,`co-operativebank-244`.`applicant`.`lname` AS `lname`,`co-operativebank-244`.`applicant`.`father_name` AS `father_name`,`co-operativebank-244`.`applicant`.`gender` AS `gender`,`co-operativebank-244`.`applicant`.`dob` AS `dob`,`co-operativebank-244`.`applicant`.`address` AS `address`,`co-operativebank-244`.`applicant`.`city` AS `city`,`co-operativebank-244`.`applicant`.`state` AS `state`,`co-operativebank-244`.`applicant`.`pin` AS `pin`,`co-operativebank-244`.`applicant`.`mobile` AS `mobile`,`co-operativebank-244`.`applicant`.`pan` AS `pan`,`co-operativebank-244`.`applicant`.`adhar` AS `adhar`,`co-operativebank-244`.`applicant`.`voter` AS `voter`,`co-operativebank-244`.`applicant`.`occupation` AS `occupation`,`co-operativebank-244`.`applicant`.`income` AS `income`,`co-operativebank-244`.`applicant`.`verify` AS `verify`,`co-operativebank-244`.`applicant`.`Acc_No` AS `Acc_No`,`dc`.`spno` AS `spno` from `co-operativebank-244`.`applicant` join `co-operativebank-244`.`deposit_acc` `dc` where (`dc`.`acc_no` = `co-operativebank-244`.`applicant`.`Acc_No`) group by `co-operativebank-244`.`applicant`.`Acc_No`
md5=c5501a0ccf827f35b99bb2ad9c4af486
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-20 05:43:34
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-244`.`applicant`.`no` AS `no`,`co-operativebank-244`.`applicant`.`code` AS `code`,`co-operativebank-244`.`applicant`.`initial` AS `initial`,`co-operativebank-244`.`applicant`.`fname` AS `fname`,`co-operativebank-244`.`applicant`.`mname` AS `mname`,`co-operativebank-244`.`applicant`.`lname` AS `lname`,`co-operativebank-244`.`applicant`.`father_name` AS `father_name`,`co-operativebank-244`.`applicant`.`gender` AS `gender`,`co-operativebank-244`.`applicant`.`dob` AS `dob`,`co-operativebank-244`.`applicant`.`address` AS `address`,`co-operativebank-244`.`applicant`.`city` AS `city`,`co-operativebank-244`.`applicant`.`state` AS `state`,`co-operativebank-244`.`applicant`.`pin` AS `pin`,`co-operativebank-244`.`applicant`.`mobile` AS `mobile`,`co-operativebank-244`.`applicant`.`pan` AS `pan`,`co-operativebank-244`.`applicant`.`adhar` AS `adhar`,`co-operativebank-244`.`applicant`.`voter` AS `voter`,`co-operativebank-244`.`applicant`.`occupation` AS `occupation`,`co-operativebank-244`.`applicant`.`income` AS `income`,`co-operativebank-244`.`applicant`.`verify` AS `verify`,`co-operativebank-244`.`applicant`.`Acc_No` AS `Acc_No`,`dc`.`spno` AS `spno` from `co-operativebank-244`.`applicant` join `co-operativebank-244`.`deposit_acc` `dc` where (`dc`.`acc_no` = `co-operativebank-244`.`applicant`.`Acc_No`) group by `co-operativebank-244`.`applicant`.`Acc_No`
