SELECT t1.EMP_ID,
t1.CURRENT_HOURS,
t1.CURRENT_AMOUNT AS [401K-MATCH],
t2.CURRENT_AMOUNT AS [401K-TRAD]
FROM PROC_EMP_PAYDETAIL t1
LEFT JOIN PROC_EMP_PAYDETAIL t2 ON t1.EMP_ID = t2.EMP_ID
AND t2.EARN_ID = '401K-TRAD'
WHERE t1.EARN_ID = '401K-MATCH'
Open in new window