Right Joins

Use a right join to include all the records in the Child table that meet the selection criteria and only those rows in the Parent table where the values in the fields you are joining are equal.

Example: You want a list of all your activities. If the activity is associated with an opportunity, select it as well. The records shown in the Join Results column are 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
Opportunity 1	Activity 1		Activity 1 Activity 2 Activity 3 Activity 4 Activity 6 Activity 7 Opportunity1 Opportunity4 Opportunity5
Opportunity 2	Activity 2
Opportunity 3	Activity 3	(Opportunity1)
Opportunity 4	Activity 4	(Opportunity4)
Opportunity 5	Activity 5
	Activity 6	(Opportunity5)
	Activity 7	(Opportunity1)