SELECT Cases.CaseNum, Cases.CaseID, GoalMethods.GoalMethodID, GoalMethods.Method, Pedagogy.PedID, Pedagogy.Pedagogy, Synchronicity.SyncID, Synchronicity.Synchronicity, Interactivity.InteractID, Interactivity.Interactivity FROM GoalMethods LEFT JOIN ValueGoals ON ValueGoals.ValueGoalID = GoalMethods.ValueGoalID LEFT JOIN CaseValues ON CaseValues.CaseValueID = ValueGoals.CaseValueID LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN Interactivity ON Interactivity.InteractID = GoalMethods.InteractID LEFT JOIN Pedagogy ON Pedagogy.PedID = GoalMethods.PedID LEFT JOIN Synchronicity ON Synchronicity.SyncID = GoalMethods.SyncID ORDER BY Synchronicity, Pedagogy, Interactivity, Method ASC SELECT GoalMethods.Method, MethodConditions.GoalMethodID, MethodConditions.Effectiveness, MethodConditions.Conditions, Detail.DetailID, Detail.Detail, Focus.FocusID, Focus.Focus FROM GoalMethods LEFT JOIN MethodConditions ON MethodConditions.GoalMethodID = GoalMethods.GoalMethodID LEFT JOIN Detail ON Detail.DetailID = MethodConditions.DetailID LEFT JOIN Focus ON Focus.FocusID = MethodConditions.FocusID WHERE GoalMethods.GoalMethodID = #URL.MethodID# ORDER BY Focus, Detail, Effectiveness, Conditions ASC SELECT Cases.CaseNum, Cases.CaseID, GoalClass.GoalClass, GoalMethods.GoalMethodID, GoalMethods.Method, Pedagogy.PedID, Pedagogy.Pedagogy, Synchronicity.SyncID, Synchronicity.Synchronicity, Interactivity.InteractID, Interactivity.Interactivity FROM GoalClass LEFT JOIN ValueGoals ON ValueGoals.GoalClassID = GoalClass.GoalClassID LEFT JOIN CaseValues ON CaseValues.CaseValueID = ValueGoals.CaseValueID LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN GoalMethods ON GoalMethods.ValueGoalID = ValueGoals.ValueGoalID LEFT JOIN Interactivity ON Interactivity.InteractID = GoalMethods.InteractID LEFT JOIN Pedagogy ON Pedagogy.PedID = GoalMethods.PedID LEFT JOIN Synchronicity ON Synchronicity.SyncID = GoalMethods.SyncID WHERE GoalClass.GoalClassID = #URL.GoalClassID# ORDER BY Synchronicity, Pedagogy, Interactivity, Method ASC SELECT Cases.CaseNum, Cases.CaseID, Goals.Goal, GoalMethods.GoalMethodID, GoalMethods.Method, Pedagogy.PedID, Pedagogy.Pedagogy, Synchronicity.SyncID, Synchronicity.Synchronicity, Interactivity.InteractID, Interactivity.Interactivity FROM Goals LEFT JOIN ValueGoals ON ValueGoals.GoalID = Goals.GoalID LEFT JOIN CaseValues ON CaseValues.CaseValueID = ValueGoals.CaseValueID LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN GoalMethods ON GoalMethods.ValueGoalID = ValueGoals.ValueGoalID LEFT JOIN Interactivity ON Interactivity.InteractID = GoalMethods.InteractID LEFT JOIN Pedagogy ON Pedagogy.PedID = GoalMethods.PedID LEFT JOIN Synchronicity ON Synchronicity.SyncID = GoalMethods.SyncID WHERE Goals.GoalID = #URL.GoalID# ORDER BY Synchronicity, Pedagogy, Interactivity, Method ASC SELECT Cases.CaseID, Cases.CaseNum, Cases.Citation, CaseValues.CaseValueID, Cases.Hyperlink, ValueNames.ValueID, ValueNames.Value, ValueClass.ValueClassID, ValueClass.ValueClass, ValueGoals.ValueGoalID, Goals.GoalID, Goals.Goal, GoalClass.GoalClassID, GoalClass.GoalClass, GoalMethods.GoalMethodID, GoalMethods.Method, Interactivity.InteractID, Interactivity.Interactivity, Pedagogy.PedID, Pedagogy.Pedagogy, Synchronicity.SyncID, Synchronicity.Synchronicity FROM GoalMethods LEFT JOIN ValueGoals ON ValueGoals.ValueGoalID = GoalMethods.ValueGoalID LEFT JOIN Interactivity ON Interactivity.InteractID = GoalMethods.InteractID LEFT JOIN Pedagogy ON Pedagogy.PedID = GoalMethods.PedID LEFT JOIN Synchronicity ON Synchronicity.SyncID = GoalMethods.SyncID LEFT JOIN CaseValues ON CaseValues.CaseValueID = ValueGoals.CaseValueID LEFT JOIN Cases ON Cases.CaseID = CaseValues.CaseID LEFT JOIN ValueNames ON ValueNames.ValueID = CaseValues.ValueID LEFT JOIN ValueClass ON ValueClass.ValueClassID = ValueNames.ValueClassID LEFT JOIN Goals ON Goals.GoalID = ValueGoals.GoalID LEFT JOIN GoalClass ON GoalClass.GoalClassID = Goals.GoalClassID WHERE GoalMethods.GoalMethodID = #URL.GoalMethodID# 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#