SELECT a.emp_id, b.pay_date, b.pay_total
FROM employees a
INNER JOIN payroll b ON a.emp_id = b.emp_id
INNER JOIN (SELECT emp_id, MAX(pay_date) AS pay_date FROM payroll GROUP BY emp_id) c ON c.pay_dt = b.pay_dt AND a.emp_id = c.emp_id
WHERE a.STATUS = 'A'