TYPE=VIEW
query=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-durgapur`.`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-durgapur`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-durgapur`.`loansatm1`
md5=8fc24d607ba6d73bbb89a2d2226e1c93
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-04-03 10:13:53
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-durgapur`.`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-durgapur`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-durgapur`.`loansatm1`
