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 | 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) | ||
