I want to append only data to payroll table if employee ID (Emp_ID) and attendance Date (Atn_Date) does not exist for employee in payroll table to avoid duplicate entries
Code:
INSERT INTO Tbl_Payroll ( PR_ID, Emp_ID, Full_name, Payroll_Date, Payroll_Month, Payroll_Year, Basic_Daily_Wage, Net_Daily_Wage, Payroll_Salary, Deduction_Amount, Deduction_Type, Paid_Amount, Net_Balance, Full_Pay_Days, Basic_Pay_Days, Unpaid_Days, Payment_Satus, Notes )
SELECT Tbl_Payroll_Temp.PR_ID, Tbl_Payroll_Temp.Emp_ID, Tbl_Payroll_Temp.Full_name, Tbl_Payroll_Temp.Payroll_Date, Tbl_Payroll_Temp.Payroll_Month, Tbl_Payroll_Temp.Payroll_Year, Tbl_Payroll_Temp.Basic_Daily_Wage, Tbl_Payroll_Temp.Net_Daily_Wage, Sum(Tbl_Payroll_Temp.Payroll_Salary) AS SumOfPayroll_Salary, Sum(Tbl_Payroll_Temp.Deduction_Amount) AS SumOfDeduction_Amount, Tbl_Payroll_Temp.Deduction_Type, Sum(Tbl_Payroll_Temp.Paid_Amount) AS SumOfPaid_Amount, Sum(Tbl_Payroll_Temp.Net_Balance) AS SumOfNet_Balance, Sum(Tbl_Payroll_Temp.Full_Pay_Days) AS SumOfFull_Pay_Days, Sum(Tbl_Payroll_Temp.Basic_Pay_Days) AS SumOfBasic_Pay_Days, Sum(Tbl_Payroll_Temp.Unpaid_Days) AS SumOfUnpaid_Days, Tbl_Payroll_Temp.Payment_Satus, Tbl_Payroll_Temp.Notes
FROM Tbl_Payroll_Temp
GROUP BY Tbl_Payroll_Temp.PR_ID, Tbl_Payroll_Temp.Emp_ID, Tbl_Payroll_Temp.Full_name, Tbl_Payroll_Temp.Payroll_Date, Tbl_Payroll_Temp.Payroll_Month, Tbl_Payroll_Temp.Payroll_Year, Tbl_Payroll_Temp.Basic_Daily_Wage, Tbl_Payroll_Temp.Net_Daily_Wage, Tbl_Payroll_Temp.Deduction_Type, Tbl_Payroll_Temp.Payment_Satus, Tbl_Payroll_Temp.Notes;