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`.`vch_type`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`deposit` `d`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_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`,\' \',`w`.`cheque_no`,\' \',`w`.`trnsfer_acc`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,`v`.`vch_type` AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,\'\' AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\') and (`s`.`code` = \'010001\')) group by `v`.`vch_no`
md5=4f94eb3d80ecc160679aeb1b20b39333
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:23
create-version=1
source=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`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by` from (`voucher` `v` join `deposit` `d`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_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`,\' \',`w`.`cheque_no`,\' \',`w`.`trnsfer_acc`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by` from (`voucher` `v` join `withdrawl` `w`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,`v`.`vch_type` AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,\'\' AS `depo_by` from (`voucher` `v` join `shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\') and (`s`.`code` = \'010001\')) group by `v`.`vch_no`
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`.`vch_type`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`deposit` `d`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_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`,\' \',`w`.`cheque_no`,\' \',`w`.`trnsfer_acc`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,`v`.`vch_type` AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,\'\' AS `depo_by` from (`co-operativebank-bajbajia`.`voucher` `v` join `co-operativebank-bajbajia`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2018-01-13\') and (`v`.`date` <= \'2018-01-13\') and (`s`.`code` = \'010001\')) group by `v`.`vch_no`
