ms access – Payment for hours not worked.(Hint: compare hours in the transactions file to the time file,

Payment for hours not worked.(Hint: compare hours in the transactions file to the time file, Steps: summarize payroll transactions and time records for the month, join the monthly payroll to the monthly time on employee number and filter to test if regular and overtime hours in transaction file

SELECT Regular_Hours, Overtime_Hours, Reg_Hours, OT_Hrs
FROM Lenrold_Payroll_Transactions, Lenrold_Payroll_Time
WHERE Regular_Hours = Reg_Hours
AND Overtime_Hours = OT_Hrs

SELECT Lenrold_Payroll_Transactions.Regular_Hours, SUM (Lenrold_Payroll_Transactions.Regular_Hours) AS Balance, Lenrold_Payroll_Time.Reg_Hours
FROM Lenrold_Payroll_Transactions INNER JOIN Lenrold_Payroll_Time
ON Lenrold_Payroll_Transactions.Regular_Hours = Lenrold_Payroll_Time.Reg_Hours
WHERE Lenrold_Payroll_Transactions.Regular_Hours = Lenrold_Payroll_Time.Reg_Hours
GROUP BY Lenrold_Payroll_Transactions.Regular_Hours, Lenrold_Payroll_Time.Reg_Hours

I’m trying to join these two SQL statements please help