TYPE=VIEW
query=select `v`.`vch_no` AS `vch_no`,`v`.`date` AS `date`,`v`.`vch_type` AS `vch_type`,`v`.`deposit_type` AS `deposit_type`,`v`.`dr` AS `dr`,`v`.`cr` AS `cr`,`v`.`Acc_no` AS `ledger`,`l`.`name` AS `name`,`l1`.`sub_head` AS `sub_head` from ((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l`) join `co-operativebank`.`ledger` `l1`) where ((`v`.`cash_acc` = `l`.`acc_no`) and (`v`.`status` = \'1\') and (`v`.`Acc_no` = `l1`.`acc_no`))
md5=799eb002f9e1b6dbce4beba05f40ec61
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:54
create-version=1
source=select `v`.`vch_no` AS `vch_no`,`v`.`date` AS `date`,`v`.`vch_type` AS `vch_type`,`v`.`deposit_type` AS `deposit_type`,`v`.`dr` AS `dr`,`v`.`cr` AS `cr`,`v`.`Acc_no` AS `ledger`,`l`.`name` AS `name`,`l1`.`sub_head` AS `sub_head` from ((`voucher` `v` join `ledger` `l`) join `ledger` `l1`) where ((`v`.`cash_acc` = `l`.`acc_no`) and (`v`.`status` = \'1\') and (`v`.`Acc_no` = `l1`.`acc_no`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`vch_no` AS `vch_no`,`v`.`date` AS `date`,`v`.`vch_type` AS `vch_type`,`v`.`deposit_type` AS `deposit_type`,`v`.`dr` AS `dr`,`v`.`cr` AS `cr`,`v`.`Acc_no` AS `ledger`,`l`.`name` AS `name`,`l1`.`sub_head` AS `sub_head` from ((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l`) join `co-operativebank`.`ledger` `l1`) where ((`v`.`cash_acc` = `l`.`acc_no`) and (`v`.`status` = \'1\') and (`v`.`Acc_no` = `l1`.`acc_no`))
