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-244`.`account` union all select `co-operativebank-244`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-244`.`loan_account`.`name` AS `name`,`co-operativebank-244`.`loan_account`.`acc_type` AS `acc_type`,`co-operativebank-244`.`loan_account`.`sub_head` AS `sub_head` from `co-operativebank-244`.`loan_account` group by `co-operativebank-244`.`loan_account`.`acc_no`
md5=e6314e1759aabad691e1c7368d19f31f
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-19 04:30: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-244`.`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-244`.`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-244`.`account` union all select `co-operativebank-244`.`loan_account`.`acc_no` AS `acc_no`,`co-operativebank-244`.`loan_account`.`name` AS `name`,`co-operativebank-244`.`loan_account`.`acc_type` AS `acc_type`,`co-operativebank-244`.`loan_account`.`sub_head` AS `sub_head` from `co-operativebank-244`.`loan_account` group by `co-operativebank-244`.`loan_account`.`acc_no`
