SELECT GoalClass.GoalClassID, GoalClass.GoalClass, Goals.GoalID, Goals.Goal FROM Goals LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID ORDER BY GoalClass, Goal ASC SELECT ValueClass.ValueClass, GoalClass.GoalClassID, GoalClass.GoalClass, Goals.GoalID, Goals.Goal FROM ValueClass LEFT JOIN ValueNames ON ValueNames.ValueClassID = ValueClass.ValueClassID LEFT JOIN CaseValues ON CaseValues.ValueID = ValueNames.ValueID LEFT JOIN ValueGoals ON ValueGoals.CaseValueID = CaseValues.CaseValueID LEFT JOIN Goals ON Goals.GoalID = ValueGoals.GoalID LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID WHERE ValueClass.ValueClassID = #URL.ValueClassID# ORDER BY GoalClass, Goal ASC SELECT ValueNames.Value, GoalClass.GoalClassID, GoalClass.GoalClass, Goals.GoalID, Goals.Goal FROM ValueNames LEFT JOIN CaseValues ON CaseValues.ValueID = ValueNames.ValueID LEFT JOIN ValueGoals ON ValueGoals.CaseValueID = CaseValues.CaseValueID LEFT JOIN Goals ON Goals.GoalID = ValueGoals.GoalID LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID WHERE ValueNames.ValueID = #URL.ValueID# ORDER BY GoalClass, Goal ASC SELECT Cases.CaseID, Cases.CaseNum, Cases.Citation, CaseValues.CaseValueID, Cases.Hyperlink, CaseValues.ValueID, CaseValues.Value, ValueClass.ValueClassID, ValueClass.ValueClass FROM CaseValues LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN ValueClass ON ValueClass.ValueClassID = CaseValues.ValueClassID WHERE CaseValues.CaseValueID = #URL.CaseValueID# SELECT Cases.CaseID, Cases.CaseNum, Cases.Citation, CaseValues.CaseValueID, Cases.Hyperlink, CaseValues.ValueID, CaseValues.Value, ValueClass.ValueClassID, ValueClass.ValueClass, ValueGoals.ValueGoalID, ValueGoals.GoalID, ValueGoals.Goal, GoalClass.GoalClassID, GoalClass.GoalClass FROM ValueGoals LEFT JOIN GoalClass ON GoalClass.GoalClassID = ValueGoals.GoalClassID LEFT JOIN CaseValues ON CaseValues.CaseValueID = ValueGoals.CaseValueID LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN ValueClass ON ValueClass.ValueClassID = CaseValues.ValueClassID WHERE ValueGoals.ValueGoalID = #URL.ValueGoalID# SELECT Goals.GoalID, Goals.Goal FROM ValueGoals LEFT JOIN Goals ON Goals.GoalID = ValueGoals.GoalID LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID WHERE ValueGoals.ValueGoalID = #URL.ValueGoalID# SELECT Goals.GoalID, Goals.Goal, GoalClass.GoalClassID, GoalClass.GoalClass FROM Goals LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID WHERE (Goals.GoalID <> #SelectedGoal.GoalID#) ORDER BY Goal, GoalClass ASC SELECT GoalID FROM ValueGoals ORDER BY GoalID DESC