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`.`deposit` `d` join `co-operativebank`.`account` `a`) join `co-operativebank`.`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`.`withdrawl` `w` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
md5=46a8a8e5c634f7bd893cad0130f81916
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:58
create-version=1
source=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 ((`deposit` `d` join `account` `a`) join `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 ((`withdrawl` `w` join `account` `a`) join `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`.`deposit` `d` join `co-operativebank`.`account` `a`) join `co-operativebank`.`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`.`withdrawl` `w` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
