When writing queries, it is fairly simple to retrieve information from one table. In many cases, you want to retrieve data from more than one table or specify criteria in your query from a second table. In these cases, you need to link at least two tables in one query. Working with multiple tables is almost as easy as working with one table.

 

A join enables you to retrieve data from two or more records or to specify criteria from more than one record. Whenever you perform a join, you link records based on their common fields.

 

To assist users in using query joins, PeopleSoft delivers a number of predefined joins. There are two types of predefined joins: hierarchical joins and related record joins. Because these types of joins are predefined, you do not have to add any criteria to manually link the records.

 

Record Hierarchy joins have a one to many relationship. They use records that are parents or children of each other. A child table is a table that uses all the same key fields as its parent, plus one or more additional keys. The parent record in PeopleSoft Application Designer defines the hierarchical relationship.

 

Related Record joins have a one to one relationship. They use records from non-hierarchical records that are related by common fields. The prompt table edit defined for a field in PeopleSoft Application Designer determines the relationship between the records.

 

In this topic, the Records Office staff has asked you to generate a report with class meeting information for the Fall 2002 term (STRM 0475). You will use three records to build this query utilizing a record hierarchy join and a related record join.

 


Table of Contents