TYPE=VIEW
query=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-199`.`loansatm` union all select `loansatm2`.`date` AS `date`,\'0\' AS `openBal`,`loansatm2`.`LoanIssue` AS `LoanIssue`,`loansatm2`.`LoanCollection` AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-199`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-199`.`loansatm1`
md5=e1b612fe5a359b8546c53b0a761219cc
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2023-03-02 04:14:23
create-version=1
source=select  date, openBal, \'0\' as LoanIssue,\'0\' as LoanCollection, \'0\' as InstAmt from loansatm union all select date,\'0\' as openBal,LoanIssue,LoanCollection,\'0\' as InstAmt from loansatm2  union all select  date,\'0\' as openBal,\'0\' as LoanIssue,\'0\' as LoanCollection, InstAmt from loansatm1
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-199`.`loansatm` union all select `loansatm2`.`date` AS `date`,\'0\' AS `openBal`,`loansatm2`.`LoanIssue` AS `LoanIssue`,`loansatm2`.`LoanCollection` AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-199`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-199`.`loansatm1`
