SELECT
Question.questionID,
QuestionAlias.aliasText,
QuestionnaireVersion.name,
DeterminationAnswer.answer,
DeterminationAnswer.thirdPartyInd
INTO
:questionID,
:questionText,
:questionnaireName,
:answer,
:thirdPartyInd
FROM
QuestionnaireVersion,
QuestionAlias,
Question,
ThirdPartyRequestQuestion
LEFT OUTER JOIN
DeterminationAnswer
ON DeterminationAnswer.sourceID = ThirdPartyRequestQuestion.thirdPartyRequestID
AND DeterminationAnswer.questionID = ThirdPartyRequestQuestion.questionID
WHERE ThirdPartyRequestQuestion.thirdPartyRequestID = :thirdPartyRequestID
AND Question.questionID = ThirdPartyRequestQuestion.questionID
AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID
AND QuestionAlias.questionID = Question.questionID
|