Inner Joins

An inner join is the default type for local joins. Use an inner join to include only records where the values in the fields you are joining are the same in both the Parent and Child tables.

Example: You want to review any opportunities with associated activities, leaving out any opportunities without activities. The records shown in the Join Results column must be returned by this query. The specific opportunity associated with an activity is indicated in parentheses to the right of the activity.

Source Selected Join Results
OPPORTUNITY Table ACTIVITY Table  
Opportunity1 Activity 1  

Opportunity1

Opportunity4

Opportunity5

Activity 3

Activity 4

Activity 6

Activity 7

Opportunity2 Activity 2  
Opportunity3 Activity 3 (Opportunity1)
Opportunity4 Activity 4 (Opportunity4)
Opportunity5 Activity 5  
  Activity 6 (Opportunity5)
  Activity 7 (Opportunity1)
Related topics