TYPE=VIEW
query=select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`v`.`vch_no` AS `vch_no`,`v`.`vch_type` AS `vch_type`,`w`.`Amt` AS `amt`,`w`.`Withdrawl_Type` AS `Withdrawl_Type`,`a`.`Acc_Type` AS `acc_type` from ((`co-operativebank-bajbajia`.`withdrawl` `w` join `co-operativebank-bajbajia`.`account` `a`) join `co-operativebank-bajbajia`.`voucher` `v`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`status` = \'1\'))
md5=46e04911e68d69655b9a63314cfe41dc
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:29
create-version=1
source=select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`v`.`vch_no` AS `vch_no`,`v`.`vch_type` AS `vch_type`,`w`.`Amt` AS `amt`,`w`.`Withdrawl_Type` AS `Withdrawl_Type`,`a`.`Acc_Type` AS `acc_type` from ((`withdrawl` `w` join `account` `a`) join `voucher` `v`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`status` = \'1\'))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`v`.`vch_no` AS `vch_no`,`v`.`vch_type` AS `vch_type`,`w`.`Amt` AS `amt`,`w`.`Withdrawl_Type` AS `Withdrawl_Type`,`a`.`Acc_Type` AS `acc_type` from ((`co-operativebank-bajbajia`.`withdrawl` `w` join `co-operativebank-bajbajia`.`account` `a`) join `co-operativebank-bajbajia`.`voucher` `v`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`status` = \'1\'))
