TYPE=VIEW
query=select (select `co-operativebank-230`.`bank_details`.`name` from `co-operativebank-230`.`bank_details`) AS `PACS_NAME`,`dc`.`member_id` AS `LEGACY_CIF`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `father_name`,`a`.`bankacc` AS `BANK_CBS_ACCNO`,`a`.`Acc_No` AS `acc_no`,`dc`.`online` AS `online` from `co-operativebank-230`.`deposit_acc` `dc` join `co-operativebank-230`.`j_a` `a` where ((`dc`.`acc_no` = `a`.`Acc_No`) and (`dc`.`sub_head` = \'14101\')) group by `a`.`Acc_No`
md5=4210e25a5375cbeed27f06f9dd619031
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-11-02 08:00:02
create-version=1
source=select (SELECT name FROM `bank_details`) as PACS_NAME,member_id as LEGACY_CIF,a.initial,a.fname,a.mname,a.lname,a.father_name,a.bankacc as BANK_CBS_ACCNO,a.acc_no,dc.online from deposit_acc dc, j_a a where dc.acc_no=a.acc_no and dc.sub_head=\'14101\' group by a.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select (select `co-operativebank-230`.`bank_details`.`name` from `co-operativebank-230`.`bank_details`) AS `PACS_NAME`,`dc`.`member_id` AS `LEGACY_CIF`,`a`.`initial` AS `initial`,`a`.`fname` AS `fname`,`a`.`mname` AS `mname`,`a`.`lname` AS `lname`,`a`.`father_name` AS `father_name`,`a`.`bankacc` AS `BANK_CBS_ACCNO`,`a`.`Acc_No` AS `acc_no`,`dc`.`online` AS `online` from `co-operativebank-230`.`deposit_acc` `dc` join `co-operativebank-230`.`j_a` `a` where ((`dc`.`acc_no` = `a`.`Acc_No`) and (`dc`.`sub_head` = \'14101\')) group by `a`.`Acc_No`
