Whenever you need to get data from 2 tables, you can use join on those tables using PSQuery. Joins retrieve data from more than one table, presenting the data as if it came from one table. PSQuery links the tables, based on common columns, and links the rows on the two tables by common values in the shared columns.
In this video you will learn how to join 2 tables using PSQuery
How to track user activity in PeopleSoft
New Reporting Features in PeopleTools 8.60
Find PeopleSoft queries a user has access to [SQL]
BI Publisher New Features in PeopleTools 8.57
PUM: Finding PUM maintenance info using PS Query
How to access SQL for a Private PS query of another user
How to copy or share private ps query with another user
How To Transfer Private PS Query From One User To Another
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Once tables are established as a standard join, is there a way to go back and change that standard join to a Left join? I found the only way to do this is to delete the table and re-add it.
I think that is the only way to do it.
I have the same question but was hoping for a different answer. Thanks.