query to be make.txt

SELECT 
    hrm_employee_monthlyleave_balance.OpeningCL, 
    hrm_employee_monthlyleave_balance.CreditedCL, 
    hrm_employee_monthlyleave_balance.AvailedCL, 
    hrm_employee_monthlyleave_balance.BalanceCL,
    hrm_employee_monthlyleave_balance.OpeningSL, 
    hrm_employee_monthlyleave_balance.CreditedSL, 
    hrm_employee_monthlyleave_balance.AvailedSL, 
    hrm_employee_monthlyleave_balance.BalanceSL,
    hrm_employee_monthlyleave_balance.OpeningPL, 
    hrm_employee_monthlyleave_balance.CreditedPL, 
    hrm_employee_monthlyleave_balance.AvailedPL, 
    hrm_employee_monthlyleave_balance.BalancePL,
    hrm_employee_monthlyleave_balance.OpeningEL, 
    hrm_employee_monthlyleave_balance.CreditedEL, 
    hrm_employee_monthlyleave_balance.AvailedEL, 
    hrm_employee_monthlyleave_balance.BalanceEL,
    hrm_employee_monthlyleave_balance.OpeningOL, 
    hrm_employee_monthlyleave_balance.CreditedOL, 
    hrm_employee_monthlyleave_balance.AvailedOL, 
    hrm_employee_monthlyleave_balance.BalanceOL
FROM 
    hrm_employee_monthlyleave_balance
JOIN 
    hrm_month  ON hrm_employee_monthlyleave_balance.Month = hrm_month.MonthId
WHERE 
    hrm_employee_monthlyleave_balance.EmployeeID = 78
    AND hrm_month.MonthName = 'October'
    AND hrm_employee_monthlyleave_balance.Year = 2024;

    for attendance My Leave Table