Query Manager enables you to create queries that include multiple-table joins.


Joins retrieve data from more than one table, presenting the data as if it came from one table. PeopleSoft Query links the tables, based on common columns, and links the rows on the two tables by common values in the shared columns.


The procedure for joining tables differs depending on how the tables that are being joined are related to each other. Query Manager recognizes three types of joins: record hierarchy, related record, and any record.


In this topic, you will review:

• Record hierarchy joins.

• Related record joins.

• Any record joins.

• Left outer joins.

Table of Contents