TYPE=VIEW
query=select `d`.`acc_no` AS `acc_no`,`d`.`fd_sv_acc_no` AS `savingacc`,`d`.`sub_head` AS `sub_head` from (`co-operativebank-198`.`deposit_acc` `d` join `co-operativebank-198`.`shares` `s`) where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
md5=3e8b34be8af4e4bf013b80d60343e23c
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:36
create-version=1
source=select  `d`.`acc_no`  AS  `acc_no` ,\n `d`.`fd_sv_acc_no`  AS  `savingacc` ,\n `d`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-198`.`deposit_acc`  `d`  join  `co-operativebank-198`.`shares`  `s`  ) where (  `d`.`fd_sv_acc_no`  =  `s`.`acc_no`  ) group  by  `d`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`acc_no` AS `acc_no`,`d`.`fd_sv_acc_no` AS `savingacc`,`d`.`sub_head` AS `sub_head` from (`co-operativebank-198`.`deposit_acc` `d` join `co-operativebank-198`.`shares` `s`) where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
