Mark-101232, was going to go down that road, but I thought I needed to add an INNER JOIN statement to the two sub queries. If this not the case,...

Sorry. I should have explained this portion of the statement:

WHERE JOB.EFFDT = (SELECT MAX(A.EFFDT) FROM PS_JOB A

WHERE A.EMPLID = JOB.EMPLID

AND A.EMPL_RCD_NBR = JOB.EMPL_RCD_NBR

AND...