TYPE=VIEW
query=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-211`.`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-211`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-211`.`loansatm1`
md5=8a2b4745522860bfe259297bf51e19cf
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-01-15 03:02:16
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-211`.`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-211`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-211`.`loansatm1`
