PS Query - Use a subquery as a Select field in PS/Query
Hello,
We are on PS 8.58 Tools and PS 9.2. Need help on PS Query requirement. Can anyone tell me how to make subquery a select field in PS/Query? expression in PS Query has restrictions while adding from clause
Example
Select emplid,action ,(select Last_date_worked from ps_job k where k.emplid=j.emplid and k.last_date_worked=sysdate)
from ps_job J where J.EFFDT=(Select max(j1.effdt) from ps_job j1 where j1.emplid=j.emplid and j1.empl_rcd=j.empl_rcd and j1.effdt<=sysdate) followed with effseq logic etc.
Thank you,
Sudha