Operation Details |
Description: | Reads goal name, goal ID, expectedStartDate and expectedEndDate for a baseline. |
Sterotype: | ns |
SQL |
SELECT Goal.name, Goal.goalID, PlannedGoal.plannedGoalID, Baseline.expectedStartDate, Baseline.expectedEndDate, Baseline.actualStartDate, Baseline.actualEndDate INTO :name, :goalID, :plannedGoalID, :expectedStartDate, :expectedEndDate, :actualStartDate, :actualEndDate FROM Baseline, PlannedGoal, Goal WHERE Baseline.baseLineID = :baseLineID AND PlannedGoal.plannedGoalID = Baseline.plannedGoalID AND Goal.goalID = PlannedGoal.goalID |