I have the following query:
Activity Name] from tblOrgGoals G
Inner Join tblOrgObjectives O on G.GoalID = O.GoalID
Inner Join tblOrgPI P on O.ObjectiveID = P.ObjectiveID
Inner Join tblOrgActivities A on P.PIID = A.PIID
It only gives me records that are complete having all tables connected with actual records. However, I have some tables that are incomplete. For example, tblOrgActivities does not have and Activity for every record in tblOrgObjectives.
Is there a way to query all the above records and show even orphan records. (See attachment highlighted in yellow)