TYPE=VIEW
query=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`deposit` `d` where ((`v`.`Acc_no` = \'010001000236\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2019-04-18\') and (`v`.`date` <= \'2020-04-17\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`withdrawl` `w` where ((`v`.`Acc_no` = \'010001000236\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2019-04-18\') and (`v`.`date` <= \'2020-04-17\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
md5=1a0cccecc8832068944fe41d510d3c5e
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2020-04-17 11:38:14
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(lfnof,\'\',v.vch_type,\' \',if(d.cheque_acc_no=\'\',d.cheque_no,d.cheque_acc_no)) vch_type,v.Dr,v.Cr,d.Deposited_by as depo_by,v.user_code FROM `voucher` v, deposit d WHERE v.acc_no=\'010001000236\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2019-04-18\' and v.date<=\'2020-04-17\' group by no,vch_type,date,amt union all select v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',if(w.cheque_no=\'\', w.trnsfer_acc,w.cheque_no)) as vch_type,v.Dr,v.Cr,w.Withdrawn_by as depo_by,v.user_code FROM `voucher` v,withdrawl w where v.acc_no=\'010001000236\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2019-04-18\' and v.date<=\'2020-04-17\' group by no,vch_type,date,amt
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`deposit` `d` where ((`v`.`Acc_no` = \'010001000236\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2019-04-18\') and (`v`.`date` <= \'2020-04-17\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`withdrawl` `w` where ((`v`.`Acc_no` = \'010001000236\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2019-04-18\') and (`v`.`date` <= \'2020-04-17\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
