TYPE=VIEW
query=select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-238`.`libities` `i` join `co-operativebank-238`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\')) union all select `co-operativebank-238`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-238`.`loan_account`.`name` AS `name` from `co-operativebank-238`.`loan_account` group by `co-operativebank-238`.`loan_account`.`acc_no`
md5=1e90ddf4576c8bfdfd0ab9eb3668caec
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-10-05 11:15:28
create-version=1
source=select  `i`.`code`  AS  `acc_no` ,\nif( (  `i`.`draw_bank`  =  \'\' ),  `s`.`sub_head` ,  `i`.`draw_bank`  )  AS  `name`  from (  `co-operativebank-238`.`libities`  `i`  join  `co-operativebank-238`.`sub_head`  `s`  ) where ( (  `s`.`code`  =  `i`.`sub_head`  ) and (  `i`.`code`  like  \'LIB%\' ) ) union  all  select  `loan_account`.`acc_no`  AS  `acc_no` ,\n `loan_account`.`name`  AS  `name`  from  `co-operativebank-238`.`loan_account`  group  by  `loan_account`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-238`.`libities` `i` join `co-operativebank-238`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\')) union all select `co-operativebank-238`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-238`.`loan_account`.`name` AS `name` from `co-operativebank-238`.`loan_account` group by `co-operativebank-238`.`loan_account`.`acc_no`
