SELECT
OutcomeScoreAssociation.outcomeScoreAssociationID,
OutcomeScoreAssociation.outcomeID,
OutcomeScoreAssociation.minimumScore,
OutcomeScoreAssociation.maximumScore,
OutcomeScoreAssociation.value,
OutcomeScoreAssociation.flag,
DAOutcome.outcomeName
INTO
:outcomeScoreAssociationID,
:outcomeID,
:minimumScore,
:maximumScore,
:value,
:flag,
:outcomeName
FROM
OutcomeScoreAssociation,
DAOutcome
WHERE OutcomeScoreAssociation.decisionMatrixVersionID = :decisionMatrixVersionID
AND OutcomeScoreAssociation.outcomeID = DAOutcome.outcomeID
ORDER BY outcomeName
|