I am trying to JOIN several tables that will show me what we have entered with Goals, Objectives, Activities, PI and Setbacks with the joining of the attached tables.
Here is the sql string I am using:
select g.Agency,g.Goal,o.Objective,p.PI,P.Method,a.[ActivityName],P.[ProjectedHours],a.Data, s.ProgressSetback
from tblOrgGoals G
LEFT Join tblOrgObjectives O on G.GoalID = O.GoalID
LEFT Join tblOrgActivities A on O.ObjectiveID = A.ObjectiveID
LEFT Join tblOrgMonthlyProgressSetbacks S on A.ActivityID = s.activityID
LEFT Join tblOrgPI P on P.ActivityID = A.ActivityID
Where G.AgencyID = 74 And S.MonthlyID = 4 order by G.Agency,G.Goal
Am I on the right track?