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 would 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
Opportunity1

Activity 1

 

Opportunity4
Opportunity2

Activity 2

 

Opportunity5
Opportunity3

Activity 3

(Opportunity1)

Activity 3
Opportunity4

Activity 4

(Opportunity4)

Activity 4
Opportunity5

Activity 5

 

Activity 6
 

Activity 6

(Opportunity5)

Activity 7
 

Activity 7

(Opportunity1)

 

 

Related Topics

Join Example

 

Tell us how we can make the Help better.