|
select distinct e.emplid, e.check_voucher_ind, j.empl_status, j.effdt
from ps_employment e, ps_job j
where e.emplid = j.emplid
and j.emplid = '105917'
and j.effdt =(select max(j2.effdt) from ps_job j2 where j.emplid = j2.emplid)
order by check_voucher_ind
|