You use the previous lessons to master the basic functionality of Query Manager in PeopleSoft Query. This lesson introduces you to the advanced functionality of PeopleSoft Query and the PeopleSoft Pure Internet Architecture.


Upon completion of this lesson, you will be able to:

• Use aggregate functions.

• Apply an aggregate function to a field.

• Describe subqueries.

• Work with subqueries.

• Describe unions.

• Work with unions.

• Describe joining records.

• Create record hierarchy joins.

• Create related record joins.

• Create any record joins.

• Create left outer joins.

Table of Contents