PeopleSoft Multiple Jobs (Primary vs Secondary)
I'm trying to find users in our database who have 2 or more active primary jobs.
I have a SQL Statement which shows me employees with no primary job.
SELECT DISTINCT A.EMPLID
FROM PS_JOB A
Where not exists (SELECT 'X' FROM PS_JOB X
WHERE X.JOB_INDICATOR = 'P'
AND A.EMPLID = X.EMPLID)
How would I write a sql statement showing me employees in the database
who have 2 or more active primary jobs?
Mike