TYPE=VIEW
query=select `a`.`sl_no` AS `sl_no`,`a`.`code` AS `code`,`a`.`head_type` AS `head_type`,(sum(`a`.`cur_bal`) - sum(`a`.`bal`)) AS `cur_bal`,`a`.`bal` AS `bal`,`a`.`main_head` AS `main_head` from `co-operativebank-243`.`ass_exp_0` `a` group by `a`.`code`
md5=8f17ce707168db7535d8e4c8d3d1e587
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2025-09-15 05:27:52
create-version=1
source=select  `a`.`sl_no`  AS  `sl_no` ,\n `a`.`code`  AS  `code` ,\n `a`.`head_type`  AS  `head_type` ,\n( sum(  `a`.`cur_bal`  )  - sum(  `a`.`bal`  )  ) AS  `cur_bal` ,\n `a`.`bal`  AS  `bal` ,\n `a`.`main_head`  AS  `main_head`  from  `co-operativebank-243`.`ass_exp_0`  `a`  group  by  `a`.`code`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`sl_no` AS `sl_no`,`a`.`code` AS `code`,`a`.`head_type` AS `head_type`,(sum(`a`.`cur_bal`) - sum(`a`.`bal`)) AS `cur_bal`,`a`.`bal` AS `bal`,`a`.`main_head` AS `main_head` from `co-operativebank-243`.`ass_exp_0` `a` group by `a`.`code`
