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`.`deposit_acc` `d` join `co-operativebank`.`shares` `s` where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
md5=0a9b39438d1796eeb0a4d1423d0c1c74
updatable=0
algorithm=0
definer_user=root
definer_host=127.0.0.1
suid=2
with_check_option=0
timestamp=2022-07-27 12:54:23
create-version=1
source=SELECT d.acc_no,fd_sv_acc_no as savingacc, d.sub_head FROM `deposit_acc` d,shares s WHERE 	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`.`deposit_acc` `d` join `co-operativebank`.`shares` `s` where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
