left join
py_process_labour_welfare
on
py_pay_group.pg_code = py_process_labour_welfare.pg_code

select payperiod_sdesc,gross_pay,esi_employer_contribution,employerContribution
    from
    py_process_emp_status_approved
    left join
    py_process_tds_pf_pt
    on
    py_process_emp_status_approved.ou_code = py_process_tds_pf_pt.ou_code
    left join
    py_pay_group
    on
    py_process_tds_pf_pt.pg_code = py_pay_group.pg_code
    left join
    py_process_labour_welfare
    on
    py_pay_group.pg_code = py_process_labour_welfare.pg_code
    left join
    py_pay_period
    on
    py_process_labour_welfare.payperiod_code = py_pay_period.payperiod_code
    left join
    py_payroll_calendar
    on
    py_pay_period.paycal_code = py_payroll_calendar.paycal_code