TYPE=VIEW
query=select `d`.`Date` AS `date`,`d`.`Acc_No` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `acc_type`,`d`.`Deposit_Type` AS `deposit_type`,\'Deposit\' AS `vch_type`,`d`.`Amt` AS `cr_amt`,\'0\' AS `dr_amt` from ((`co-operativebank-henria`.`deposit` `d` join `co-operativebank-henria`.`account` `a`) join `co-operativebank-henria`.`bank_account` `ba`) where ((`d`.`Acc_No` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`) and (`d`.`status` = \'1\')) union all select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `text`,`w`.`Withdrawl_Type` AS `withdrawl_type`,\'Withdrawl\' AS `Withdrawl`,0 AS `0`,`w`.`Amt` AS `amt` from ((`co-operativebank-henria`.`withdrawl` `w` join `co-operativebank-henria`.`account` `a`) join `co-operativebank-henria`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
md5=75e1772c1f364004d01c1097ae54622d
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-15 17:07:13
create-version=1
source=select  `d`.`Date`  AS  `date` ,\n `d`.`Acc_No`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n `ba`.`text`  AS  `acc_type` ,\n `d`.`Deposit_Type`  AS  `deposit_type` ,\n \'Deposit\' AS  `vch_type` ,\n `d`.`Amt`  AS  `cr_amt` ,\n \'0\' AS  `dr_amt`  from ( (  `co-operativebank-henria`.`deposit`  `d`  join  `co-operativebank-henria`.`account`  `a`  ) join  `co-operativebank-henria`.`bank_account`  `ba`  ) where ( (  `d`.`Acc_No`  =  `a`.`Acc_no`  ) and (  `ba`.`value`  =  `a`.`Acc_Type`  ) and (  `d`.`status`  =  \'1\' ) ) union  all  select  `w`.`Date`  AS  `date` ,\n `w`.`Acc_no`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n `ba`.`text`  AS  `text` ,\n `w`.`Withdrawl_Type`  AS  `withdrawl_type` ,\n \'Withdrawl\' AS  `Withdrawl` ,\n0 AS  `0` ,\n `w`.`Amt`  AS  `amt`  from ( (  `co-operativebank-henria`.`withdrawl`  `w`  join  `co-operativebank-henria`.`account`  `a`  ) join  `co-operativebank-henria`.`bank_account`  `ba`  ) where ( (  `w`.`Acc_no`  =  `a`.`Acc_no`  ) and (  `ba`.`value`  =  `a`.`Acc_Type`  ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`Date` AS `date`,`d`.`Acc_No` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `acc_type`,`d`.`Deposit_Type` AS `deposit_type`,\'Deposit\' AS `vch_type`,`d`.`Amt` AS `cr_amt`,\'0\' AS `dr_amt` from ((`co-operativebank-henria`.`deposit` `d` join `co-operativebank-henria`.`account` `a`) join `co-operativebank-henria`.`bank_account` `ba`) where ((`d`.`Acc_No` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`) and (`d`.`status` = \'1\')) union all select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `text`,`w`.`Withdrawl_Type` AS `withdrawl_type`,\'Withdrawl\' AS `Withdrawl`,0 AS `0`,`w`.`Amt` AS `amt` from ((`co-operativebank-henria`.`withdrawl` `w` join `co-operativebank-henria`.`account` `a`) join `co-operativebank-henria`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
