Select  pay_year, pay_month, pay_emp_id, sum(pay_basic_salary) as sum_pay_basic_salary, sum(pay_ot_10_amount) as sum_pay_ot_10_amount, sum(pay_ot_15_amount) as sum_pay_ot_15_amount, sum(pay_ot_20_amount) as sum_pay_ot_20_amount, sum(pay_ot_30_amount) as sum_pay_ot_30_amount, sum(pay_unpay_amount) as sum_pay_unpay_amount, sum(pay_late_in_amount) as sum_pay_late_in_amount, sum(pay_early_out_amount) as sum_pay_early_out_amount, sum(pay_lunch_late_in_amount) as sum_pay_lunch_late_in_amount, sum(pay_earning_amount) as sum_pay_earning_amount, sum(pay_allowance_01_amount) as sum_pay_allowance_01_amount, sum(pay_allowance_02_amount) as sum_pay_allowance_02_amount, sum(pay_allowance_03_amount) as sum_pay_allowance_03_amount, sum(pay_allowance_04_amount) as sum_pay_allowance_04_amount, sum(pay_allowance_05_amount) as sum_pay_allowance_05_amount, sum(pay_allowance_06_amount) as sum_pay_allowance_06_amount, sum(pay_allowance_07_amount) as sum_pay_allowance_07_amount, sum(pay_allowance_08_amount) as sum_pay_allowance_08_amount, sum(pay_allowance_09_amount) as sum_pay_allowance_09_amount, sum(pay_allowance_10_amount) as sum_pay_allowance_10_amount, sum(pay_deduction_01_amount) as sum_pay_deduction_01_amount, sum(pay_deduction_02_amount) as sum_pay_deduction_02_amount, sum(pay_deduction_03_amount) as sum_pay_deduction_03_amount, sum(pay_deduction_04_amount) as sum_pay_deduction_04_amount, sum(pay_deduction_05_amount) as sum_pay_deduction_05_amount, sum(pay_deduction_06_amount) as sum_pay_deduction_06_amount, sum(pay_deduction_07_amount) as sum_pay_deduction_07_amount, sum(pay_deduction_amount) as sum_pay_deduction_amount, sum(pay_epf_employee) as sum_pay_epf_employee, sum(pay_epf_employer) as sum_pay_epf_employer, sum(pay_socso_employee) as sum_pay_socso_employee, sum(pay_socso_employer) as sum_pay_socso_employer, sum(pay_incometax_employee) as sum_pay_incometax_employee, sum(pay_CP38) as sum_pay_CP38, sum(pay_incometax_employer) as sum_pay_incometax_employer, sum(pay_hrdf_employer) as sum_pay_hrdf_employer, sum(pay_ab_amount) as sum_pay_ab_amount, sum(pay_ic_amount) as sum_pay_ic_amount, sum(pay_net_amount) as sum_pay_net_amount, sum(pay_lunch_early_out_amount) as sum_pay_lunch_early_out_amount, pay_branch_id, emp_id, emp_user_id, emp_card_no, emp_name, emp_nric_no, emp_dept_id, emp_workhour_id, emp_branch_id, emp_category_id, emp_job_category_id, emp_job_grade_id from PAY201202 left outer join employee on PAY201202.pay_emp_id = employee.emp_id group by pay_year, pay_month, pay_emp_id, pay_branch_id, emp_id, emp_user_id, emp_card_no, emp_name, emp_nric_no, emp_dept_id, emp_workhour_id, emp_branch_id, emp_category_id, emp_job_category_id, emp_job_grade_id