TYPE=VIEW
query=select `h`.`code` AS `code`,`h`.`head` AS `HEAD_TEXT`,sum(`v`.`cr`) AS `CR`,sum(`v`.`dr`) AS `DR`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal`,`v`.`head` AS `head`,`ht`.`code` AS `htcode` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` join `co-operativebank`.`head_type` `ht` where ((`ht`.`code` = `h`.`head_type`) and (`ht`.`code` <> 28000) and (`ht`.`code` <> 22000) and (`v`.`head` = `h`.`code`) and (`v`.`date` < \'2017-04-01\')) group by `ht`.`code` union all select `h`.`code` AS `code`,`h`.`head` AS `HEAD_TEXT`,sum(`v`.`dr`) AS `CR`,sum(`v`.`cr`) AS `DR`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `opbal`,`v`.`head` AS `head`,`ht`.`code` AS `htcode` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` join `co-operativebank`.`head_type` `ht` where ((`ht`.`code` = `h`.`head_type`) and (`ht`.`code` = \'28000\') and (`ht`.`code` = \'22000\') and (`v`.`head` = `h`.`code`) and (`v`.`date` < \'2017-04-01\')) group by `ht`.`code`
md5=788740df5ae2bb9f9baa6c71921556b5
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2017-09-13 04:40:31
create-version=1
source=select h.code,h.head HEAD_TEXT,sum(cr) CR ,sum(dr) DR, (SUM(CR)-SUM(DR)) opbal, v.head,ht.code htcode from voucher v,head h,head_type ht where ht.code=h.head_type AND HT.CODE<>28000 AND HT.CODE<>22000 and v.head=h.code and v.date<\'2017-04-01\' group by ht.code UNION ALL select h.code,h.head HEAD_TEXT,sum(DR) CR ,sum(CR) DR,(SUM(DR)-SUM(CR)) opbal,v.head,ht.code htcode from voucher v,head h,head_type ht where ht.code=h.head_type AND HT.CODE=\'28000\' AND HT.CODE=\'22000\' and v.head=h.code and v.date<\'2017-04-01\' group by ht.code
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `h`.`code` AS `code`,`h`.`head` AS `HEAD_TEXT`,sum(`v`.`cr`) AS `CR`,sum(`v`.`dr`) AS `DR`,(sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal`,`v`.`head` AS `head`,`ht`.`code` AS `htcode` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` join `co-operativebank`.`head_type` `ht` where ((`ht`.`code` = `h`.`head_type`) and (`ht`.`code` <> 28000) and (`ht`.`code` <> 22000) and (`v`.`head` = `h`.`code`) and (`v`.`date` < \'2017-04-01\')) group by `ht`.`code` union all select `h`.`code` AS `code`,`h`.`head` AS `HEAD_TEXT`,sum(`v`.`dr`) AS `CR`,sum(`v`.`cr`) AS `DR`,(sum(`v`.`dr`) - sum(`v`.`cr`)) AS `opbal`,`v`.`head` AS `head`,`ht`.`code` AS `htcode` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` join `co-operativebank`.`head_type` `ht` where ((`ht`.`code` = `h`.`head_type`) and (`ht`.`code` = \'28000\') and (`ht`.`code` = \'22000\') and (`v`.`head` = `h`.`code`) and (`v`.`date` < \'2017-04-01\')) group by `ht`.`code`
