Brilliant ... it worked. Although I've tweaked the query since and added more criteria, I wanted to share the SQL for other that experience similar issues:
SELECT A.EMPLID, B.BUSINESS_UNIT, B.EMPL_STATUS, B.BUSINESS_TITLE, B.DEPTID, A.FIRST_NAME, A.LAST_NAME, A.MIDDLE_NAME, A.GROUP_NBR...
I did see this briefly mentioned in another thread, however I am new to query so I'm unable to figure out how to make this work.
On a simple level, I tried to create a query to pull all records from HCMROLES that do not exist in JOB_FERPA, with no success.
Following is the SQL: (0 results)...
I've exhausted my efforts and seeking some assistance with this PS Query Tool (v 9.1) issue.
I am attempting to create a outer join between a table with user names and security roles (UM_IDM_HCMROLES) and a JOB table (UM_JOB_FERPA_VW).
Issue: there are several users in the HCMROLES table that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.