TYPE=VIEW
query=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-simuldari`.`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-simuldari`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-simuldari`.`loansatm1`
md5=d6c8ea7e568824f38b915a45c618a8cf
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-09-12 05:19:36
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-simuldari`.`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-simuldari`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-simuldari`.`loansatm1`
