TYPE=VIEW
query=select `account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`account`.`Acc_Type` AS `acc_type`,`account`.`Sub_Head` AS `sub_head` from `co-operativebank`.`account` union all select `loan_account`.`acc_no` AS `acc_no`,`loan_account`.`name` AS `name`,`loan_account`.`acc_type` AS `acc_type`,`loan_account`.`sub_head` AS `sub_head` from `co-operativebank`.`loan_account` group by `loan_account`.`acc_no`
md5=5aa7e32db400d9584d05db5725b9155f
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2018-05-19 04:16:55
create-version=1
source=select `account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`account`.`Acc_Type` AS `acc_type`,`account`.`Sub_Head` AS `sub_head` from `account` union all select `loan_account`.`acc_no` AS `acc_no`,`loan_account`.`name` AS `name`,`loan_account`.`acc_type` AS `acc_type`,`loan_account`.`sub_head` AS `sub_head` from `loan_account` group by `loan_account`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `account`.`Acc_no` AS `acc_no`,`account`.`Name` AS `name`,`account`.`Acc_Type` AS `acc_type`,`account`.`Sub_Head` AS `sub_head` from `co-operativebank`.`account` union all select `loan_account`.`acc_no` AS `acc_no`,`loan_account`.`name` AS `name`,`loan_account`.`acc_type` AS `acc_type`,`loan_account`.`sub_head` AS `sub_head` from `co-operativebank`.`loan_account` group by `loan_account`.`acc_no`
