TYPE=VIEW
query=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from (`co-operativebank-mohati`.`acc_bal` `v` join `co-operativebank-mohati`.`quick_name` `q`) where ((`q`.`acc_no` = `v`.`acc_no`) and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\')) and (`v`.`acc_no` <> \'\')) group by `q`.`sbacc`
md5=a17fd433da1232c7b68b59b1ffa01d55
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2020-10-16 13:11:23
create-version=1
source=select  `v`.`acc_no`  AS  `acc_no` ,\n `q`.`sbacc`  AS  `sbacc` ,\nsum(  `v`.`bal`  )  AS  `bal`  from (  `co-operativebank-mohati`.`acc_bal`  `v`  join  `co-operativebank-mohati`.`quick_name`  `q`  ) where ( (  `q`.`acc_no`  =  `v`.`acc_no`  ) and ( (  `v`.`head`  =  \'23100\' ) or (  `v`.`head`  =  \'23200\' ) ) and (  `v`.`acc_no`  <>  \'\' ) ) group  by  `q`.`sbacc`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from (`co-operativebank-mohati`.`acc_bal` `v` join `co-operativebank-mohati`.`quick_name` `q`) where ((`q`.`acc_no` = `v`.`acc_no`) and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\')) and (`v`.`acc_no` <> \'\')) group by `q`.`sbacc`
