TYPE=VIEW
query=select `account`.`Date_open` AS `date_open`,`account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`lb`.`amt` AS `bal`,`account`.`Sub_Head` AS `sub_head`,`account`.`Acc_Type` AS `acc_type` from (`co-operativebank`.`account` join `co-operativebank`.`ledger_balance` `lb`) where (`account`.`Acc_no` = `lb`.`ledger`) union all select curdate() AS `CURDATE()`,`co-operativebank`.`cash_account`.`code` AS `acc_no`,`co-operativebank`.`cash_account`.`name` AS `name`,`lb`.`amt` AS `bal`,`co-operativebank`.`cash_account`.`sub_head` AS `sub_head`,\'Cash\' AS `Cash` from (`co-operativebank`.`cash_account` join `co-operativebank`.`ledger_balance` `lb`) where (`co-operativebank`.`cash_account`.`code` = `lb`.`ledger`) union all select `la`.`date_open` AS `date_open`,`la`.`acc_no` AS `acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`lb`.`amt` AS `amt`,`la`.`sub_head` AS `sub_head`,\'CC\' AS `CC` from ((`co-operativebank`.`loan_acc` `la` join `co-operativebank`.`applicant` `a`) join `co-operativebank`.`ledger_balance` `lb`) where ((`la`.`acc_no` = `a`.`Acc_No`) and (`la`.`acc_no` = `lb`.`ledger`)) union all select `b`.`date` AS `date`,`co-operativebank`.`brw`.`code` AS `code`,`co-operativebank`.`brw`.`name` AS `name`,`lb`.`amt` AS `amt`,`co-operativebank`.`brw`.`sub_head` AS `sub_head`,\'BRW\' AS `BRW` from ((`co-operativebank`.`borrowing` `b` join `co-operativebank`.`ledger_balance` `lb`) join `co-operativebank`.`brw`) where ((`co-operativebank`.`brw`.`code` = `lb`.`ledger`) and (`co-operativebank`.`brw`.`code` = `b`.`scheme`))
md5=d91d640fbae543166ed58977b7f8abfc
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:56
create-version=1
source=select `account`.`Date_open` AS `date_open`,`account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`lb`.`amt` AS `bal`,`account`.`Sub_Head` AS `sub_head`,`account`.`Acc_Type` AS `acc_type` from (`account` join `ledger_balance` `lb`) where (`account`.`Acc_no` = `lb`.`ledger`) union all select curdate() AS `CURDATE()`,`cash_account`.`code` AS `acc_no`,`cash_account`.`name` AS `name`,`lb`.`amt` AS `bal`,`cash_account`.`sub_head` AS `sub_head`,\'Cash\' AS `Cash` from (`cash_account` join `ledger_balance` `lb`) where (`cash_account`.`code` = `lb`.`ledger`) union all select `la`.`date_open` AS `date_open`,`la`.`acc_no` AS `acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`lb`.`amt` AS `amt`,`la`.`sub_head` AS `sub_head`,\'CC\' AS `CC` from ((`loan_acc` `la` join `applicant` `a`) join `ledger_balance` `lb`) where ((`la`.`acc_no` = `a`.`Acc_No`) and (`la`.`acc_no` = `lb`.`ledger`)) union all select `b`.`date` AS `date`,`brw`.`code` AS `code`,`brw`.`name` AS `name`,`lb`.`amt` AS `amt`,`brw`.`sub_head` AS `sub_head`,\'BRW\' AS `BRW` from ((`borrowing` `b` join `ledger_balance` `lb`) join `brw`) where ((`brw`.`code` = `lb`.`ledger`) and (`brw`.`code` = `b`.`scheme`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `account`.`Date_open` AS `date_open`,`account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`lb`.`amt` AS `bal`,`account`.`Sub_Head` AS `sub_head`,`account`.`Acc_Type` AS `acc_type` from (`co-operativebank`.`account` join `co-operativebank`.`ledger_balance` `lb`) where (`account`.`Acc_no` = `lb`.`ledger`) union all select curdate() AS `CURDATE()`,`co-operativebank`.`cash_account`.`code` AS `acc_no`,`co-operativebank`.`cash_account`.`name` AS `name`,`lb`.`amt` AS `bal`,`co-operativebank`.`cash_account`.`sub_head` AS `sub_head`,\'Cash\' AS `Cash` from (`co-operativebank`.`cash_account` join `co-operativebank`.`ledger_balance` `lb`) where (`co-operativebank`.`cash_account`.`code` = `lb`.`ledger`) union all select `la`.`date_open` AS `date_open`,`la`.`acc_no` AS `acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`lb`.`amt` AS `amt`,`la`.`sub_head` AS `sub_head`,\'CC\' AS `CC` from ((`co-operativebank`.`loan_acc` `la` join `co-operativebank`.`applicant` `a`) join `co-operativebank`.`ledger_balance` `lb`) where ((`la`.`acc_no` = `a`.`Acc_No`) and (`la`.`acc_no` = `lb`.`ledger`)) union all select `b`.`date` AS `date`,`co-operativebank`.`brw`.`code` AS `code`,`co-operativebank`.`brw`.`name` AS `name`,`lb`.`amt` AS `amt`,`co-operativebank`.`brw`.`sub_head` AS `sub_head`,\'BRW\' AS `BRW` from ((`co-operativebank`.`borrowing` `b` join `co-operativebank`.`ledger_balance` `lb`) join `co-operativebank`.`brw`) where ((`co-operativebank`.`brw`.`code` = `lb`.`ledger`) and (`co-operativebank`.`brw`.`code` = `b`.`scheme`))
