TYPE=VIEW
query=select `s4`.`slno` AS `slno`,`s4`.`SB_ac_no` AS `SB_ac_no`,`s4`.`name_of_group` AS `name_of_group`,`s4`.`female_member` AS `female_member`,`s4`.`total_member` AS `total_member`,`s4`.`Account_opeing` AS `Account_opeing`,`s5`.`no_c` AS `no_c`,round((`s4`.`Amount_deposit` / `s5`.`no_c`),2) AS `Amount_deposit`,`s4`.`this_month_deposit` AS `this_month_deposit`,`s4`.`SB_accno` AS `SB_accno`,`s4`.`ID` AS `ID`,`s4`.`acc_no` AS `acc_no`,`s4`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s4`.`date_of_loan_issue` AS `date_of_loan_issue`,`s4`.`Purpose` AS `Purpose`,`s4`.`Amt_of_Loan_os` AS `Amt_of_Loan_os`,`s4`.`Recovery_amt` AS `Recovery_amt` from `co-operativebank-radhapur`.`shg_monthly_report4` `s4` join `co-operativebank-radhapur`.`shg_monthly_report5` `s5` where (`s4`.`SB_ac_no` = `s5`.`SB_ac_no`)
md5=18e16761c15ae1784e1cd0a2c511c76d
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-12-03 05:27:46
create-version=1
source=SELECT `slno`, s4.`SB_ac_no`, `name_of_group`, `female_member`, `total_member`, Account_opeing,no_c,  round((`Amount_deposit`/no_c),2) as Amount_deposit, `this_month_deposit`, `SB_accno`, `ID`, `acc_no`, `amt_of_loan_issue`, `date_of_loan_issue`, `Purpose`, `Amt_of_Loan_os`, `Recovery_amt` FROM `shg_monthly_report4` s4,`shg_monthly_report5` s5 WHERE s4.sb_ac_no=s5.SB_ac_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `s4`.`slno` AS `slno`,`s4`.`SB_ac_no` AS `SB_ac_no`,`s4`.`name_of_group` AS `name_of_group`,`s4`.`female_member` AS `female_member`,`s4`.`total_member` AS `total_member`,`s4`.`Account_opeing` AS `Account_opeing`,`s5`.`no_c` AS `no_c`,round((`s4`.`Amount_deposit` / `s5`.`no_c`),2) AS `Amount_deposit`,`s4`.`this_month_deposit` AS `this_month_deposit`,`s4`.`SB_accno` AS `SB_accno`,`s4`.`ID` AS `ID`,`s4`.`acc_no` AS `acc_no`,`s4`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s4`.`date_of_loan_issue` AS `date_of_loan_issue`,`s4`.`Purpose` AS `Purpose`,`s4`.`Amt_of_Loan_os` AS `Amt_of_Loan_os`,`s4`.`Recovery_amt` AS `Recovery_amt` from `co-operativebank-radhapur`.`shg_monthly_report4` `s4` join `co-operativebank-radhapur`.`shg_monthly_report5` `s5` where (`s4`.`SB_ac_no` = `s5`.`SB_ac_no`)
