In a related record join, you can automatically join two records based on a relationship that has been predefined in the record designer.
For example, if a field has a prompt table defined for it, PeopleSoft Query displays a join link to the right of the shared field.
In this topic, you will create related record joins.