Quote:
|
Originally Posted by Chilly McFreeze
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
|
that did it! thanks a lot Chilly!!  I see how you aliased ps_job again....clearly I have much to learn about SQL.
ratbastid - it's an oracle ADP database. antiquated would be a nice way of putting it. I only run this once every 2 weeks to capture selections on people electing paperless payroll...thanks for your input!
__________________
Until the 20th century, reality was everything humans could touch, smell, see, and hear. Since the initial publication of the charted electromagnetic spectrum, humans have learned that what they can touch, smell, see, and hear is less than one millionth of reality
|