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-milani`.`account` join `co-operativebank-milani`.`ledger_balance` `lb`) where (`account`.`Acc_no` = `lb`.`ledger`) union all select curdate() AS `CURDATE()`,`co-operativebank-milani`.`cash_account`.`code` AS `acc_no`,`co-operativebank-milani`.`cash_account`.`name` AS `name`,`lb`.`amt` AS `bal`,`co-operativebank-milani`.`cash_account`.`sub_head` AS `sub_head`,\'Cash\' AS `Cash` from (`co-operativebank-milani`.`cash_account` join `co-operativebank-milani`.`ledger_balance` `lb`) where (`co-operativebank-milani`.`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-milani`.`loan_acc` `la` join `co-operativebank-milani`.`applicant` `a`) join `co-operativebank-milani`.`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-milani`.`brw`.`code` AS `code`,`co-operativebank-milani`.`brw`.`name` AS `name`,`lb`.`amt` AS `amt`,`co-operativebank-milani`.`brw`.`sub_head` AS `sub_head`,\'BRW\' AS `BRW` from ((`co-operativebank-milani`.`borrowing` `b` join `co-operativebank-milani`.`ledger_balance` `lb`) join `co-operativebank-milani`.`brw`) where ((`co-operativebank-milani`.`brw`.`code` = `lb`.`ledger`) and (`co-operativebank-milani`.`brw`.`code` = `b`.`scheme`))
md5=20de4b7c137fc283477328d223704619
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-10-21 04:23:48
create-version=1
source=select  `account`.`Date_open`  AS  `date_open` ,\n `account`.`Acc_no`  AS  `acc_no` ,\n `account`.`Name`  AS  `name` ,\n `lb`.`amt`  AS  `bal` ,\n `account`.`Sub_Head`  AS  `sub_head` ,\n `account`.`Acc_Type`  AS  `acc_type`  from (  `co-operativebank-milani`.`account`  join  `co-operativebank-milani`.`ledger_balance`  `lb`  ) where (  `account`.`Acc_no`  =  `lb`.`ledger`  ) union  all  select curdate(  )  AS  `CURDATE()` ,\n `co-operativebank-milani`.`cash_account`.`code`  AS  `acc_no` ,\n `co-operativebank-milani`.`cash_account`.`name`  AS  `name` ,\n `lb`.`amt`  AS  `bal` ,\n `co-operativebank-milani`.`cash_account`.`sub_head`  AS  `sub_head` ,\n \'Cash\' AS  `Cash`  from (  `co-operativebank-milani`.`cash_account`  join  `co-operativebank-milani`.`ledger_balance`  `lb`  ) where (  `co-operativebank-milani`.`cash_account`.`code`  =  `lb`.`ledger`  ) union  all  select  `la`.`date_open`  AS  `date_open` ,\n `la`.`acc_no`  AS  `acc_no` ,\nconcat(  `a`.`initial` ,  \' \',  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name` ,\n `lb`.`amt`  AS  `amt` ,\n `la`.`sub_head`  AS  `sub_head` ,\n \'CC\' AS  `CC`  from ( (  `co-operativebank-milani`.`loan_acc`  `la`  join  `co-operativebank-milani`.`applicant`  `a`  ) join  `co-operativebank-milani`.`ledger_balance`  `lb`  ) where ( (  `la`.`acc_no`  =  `a`.`Acc_No`  ) and (  `la`.`acc_no`  =  `lb`.`ledger`  ) ) union  all  select  `b`.`date`  AS  `date` ,\n `co-operativebank-milani`.`brw`.`code`  AS  `code` ,\n `co-operativebank-milani`.`brw`.`name`  AS  `name` ,\n `lb`.`amt`  AS  `amt` ,\n `co-operativebank-milani`.`brw`.`sub_head`  AS  `sub_head` ,\n \'BRW\' AS  `BRW`  from ( (  `co-operativebank-milani`.`borrowing`  `b`  join  `co-operativebank-milani`.`ledger_balance`  `lb`  ) join  `co-operativebank-milani`.`brw`  ) where ( (  `co-operativebank-milani`.`brw`.`code`  =  `lb`.`ledger`  ) and (  `co-operativebank-milani`.`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-milani`.`account` join `co-operativebank-milani`.`ledger_balance` `lb`) where (`account`.`Acc_no` = `lb`.`ledger`) union all select curdate() AS `CURDATE()`,`co-operativebank-milani`.`cash_account`.`code` AS `acc_no`,`co-operativebank-milani`.`cash_account`.`name` AS `name`,`lb`.`amt` AS `bal`,`co-operativebank-milani`.`cash_account`.`sub_head` AS `sub_head`,\'Cash\' AS `Cash` from (`co-operativebank-milani`.`cash_account` join `co-operativebank-milani`.`ledger_balance` `lb`) where (`co-operativebank-milani`.`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-milani`.`loan_acc` `la` join `co-operativebank-milani`.`applicant` `a`) join `co-operativebank-milani`.`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-milani`.`brw`.`code` AS `code`,`co-operativebank-milani`.`brw`.`name` AS `name`,`lb`.`amt` AS `amt`,`co-operativebank-milani`.`brw`.`sub_head` AS `sub_head`,\'BRW\' AS `BRW` from ((`co-operativebank-milani`.`borrowing` `b` join `co-operativebank-milani`.`ledger_balance` `lb`) join `co-operativebank-milani`.`brw`) where ((`co-operativebank-milani`.`brw`.`code` = `lb`.`ledger`) and (`co-operativebank-milani`.`brw`.`code` = `b`.`scheme`))
