How to use Join in PSQuery | PeopleSoft Tutorial

How to use Join in PSQuery

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


  • Lori says:

    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.

  • Christine says:

    I have the same question but was hoping for a different answer. Thanks.

  • >