Database SQL Operation: DeterminationAnswer.searchConsolidatedQuestionAnswersByDD
Description: | |
Sterotype: | nsmulti |
SELECT
DeterminationAnswer.determinationAnswerID,
DeterminationAnswer.questionID,
DeterminationAnswer.answer,
Question.type,
Question.codeTableInd
INTO
:determinationAnswerID,
:questionID,
:answer,
:type,
:codeTableInd
FROM
DeterminationAnswer,
Question
WHERE DeterminationAnswer.questionID = Question.questionID
AND DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID
AND DeterminationAnswer.consolidationInd = :consolidationInd
|