ccmret (7/9/2013)
I am trying to get a EmpID where the PayID is not null. My problem is that an employee may have several EmpID’s.
Gosh... unless you have a DateActivated and DateInactivated column, having multiple EmpIDs for the same employee is a fundamental problem. Are you sure there's no activation/deactivation dates associated with the EmpIDs?
--Jeff Moden
Change is inevitable... Change for the better is not.