Operation Details |
Description: | Searches for outcomes associated with a sub goal. |
Sterotype: | nsmulti |
SQL |
SELECT Outcome.outcomeID, Outcome.name, Outcome.dateCreated INTO :outcomeID, :name, :dateCreated FROM SubGoalOutcomeLink, Outcome WHERE SubGoalOutcomeLink.subGoalID = :subGoalID AND Outcome.outcomeID = SubGoalOutcomeLink.outcomeID |