Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments

Joins In Query

gears

 

To review the Query Instruction pages regarding Joins, take a look at these pages:

  • Part II – Query Manager –
    • Lesson 7:  Mastering Record Joins and Selection Criteria
  • 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.

Comments are closed.