TYPE=VIEW
query=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from (`co-operativebank-bajbajia`.`acc_bal` `v` join `co-operativebank-bajbajia`.`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=0b269638d950e5bfe87df8f1d38bbc14
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:08
create-version=1
source=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from (`acc_bal` `v` join `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-bajbajia`.`acc_bal` `v` join `co-operativebank-bajbajia`.`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`
