You can create a join between two records (any record join) by selecting your initial base record, defining its output fields and associated criteria, and then returning to the Records page to select the second record.


When you return to the Records page, you see the Join Record link rather than the Add Record to the right of all listed record names.


If you have the Enable Auto Join preference selected on the Query Preferences page, PeopleSoft Query automatically attempts to join the new record to the existing record by looking for matching columns on the two records. To access the Query Preferences page, click the Preferences link on any page of Query Manager.


In this topic, you will create any record joins.

Table of Contents