Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: QTNC
  • Order by date
  1. QTNC

    PS 9.1 - Query tool issue (Outer join w/ Effdate)

    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...
  2. QTNC

    PS 9.1 - Query tool issue (Outer join w/ Effdate)

    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)...
  3. QTNC

    PS 9.1 - Query tool issue (Outer join w/ Effdate)

    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...

Part and Inventory Search

Back
Top