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-210`.`account` union all select `co-operativebank-210`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-210`.`loan_account`.`name` AS `name`,`co-operativebank-210`.`loan_account`.`acc_type` AS `acc_type`,`co-operativebank-210`.`loan_account`.`sub_head` AS `sub_head` from `co-operativebank-210`.`loan_account` group by `co-operativebank-210`.`loan_account`.`acc_no`
md5=20dfa0383af6087e77be5d268577f3d1
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2023-03-09 06:11:13
create-version=1
source=select  `account`.`Acc_no`  AS  `acc_no` ,\n `account`.`Name`  AS  `name` ,\n `account`.`Acc_Type`  AS  `acc_type` ,\n `account`.`Sub_Head`  AS  `sub_head`  from  `co-operativebank-210`.`account`  union  all  select  `loan_account`.`acc_no`  AS  `acc_no` ,\n `loan_account`.`name`  AS  `name` ,\n `loan_account`.`acc_type`  AS  `acc_type` ,\n `loan_account`.`sub_head`  AS  `sub_head`  from  `co-operativebank-210`.`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-210`.`account` union all select `co-operativebank-210`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-210`.`loan_account`.`name` AS `name`,`co-operativebank-210`.`loan_account`.`acc_type` AS `acc_type`,`co-operativebank-210`.`loan_account`.`sub_head` AS `sub_head` from `co-operativebank-210`.`loan_account` group by `co-operativebank-210`.`loan_account`.`acc_no`
