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)