To review the Query Instruction pages regarding Joins, take a look at these pages:
- Part II – Query Manager –
- Part III – Advanced Concepts –
- Lesson 12: Join Variations
- Lesson 17: Mastering Outer Joins
How to Create a Manual Join
There will occasionally be instances when you will need to join two fields that – while otherwise identical – have different names. Click the link to see a demonstration of working with that situation. The two fields are EXT_ORG_ID and LAST_SCH_ATTEND.
Effective Dates and Joining Multiple Tables
When doing table joins on effective dated information, you will rarely modify the criteria that PeopleSoft automatically creates. If you do need to change the criteria, be certain you’re changing the correct rows of criteria. This article shows how to use Effective Dates with multiple tables.