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-simuldari`.`deposit_acc` `d` join `co-operativebank-simuldari`.`shares` `s` where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
md5=2e222b6361439b2aaa16cfcaa081fee3
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-08-22 06:40:46
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-simuldari`.`deposit_acc` `d` join `co-operativebank-simuldari`.`shares` `s` where (`d`.`fd_sv_acc_no` = `s`.`acc_no`) group by `d`.`acc_no`
