[Home] [Help]
View: JTF_IH_OUTCOME_RESULTS_VL
View Text
SELECT OUTCRES.OUTCOME_ID
, OUTCRES.RESULT_ID
, OUTC.SHORT_DESCRIPTION
, RES.SHORT_DESCRIPTION
FROM JTF_IH_OUTCOME_RESULTS OUTCRES
, JTF_IH_OUTCOMES_VL OUTC
, JTF_IH_RESULTS_VL RES
WHERE OUTCRES.OUTCOME_ID = OUTC.OUTCOME_ID
AND OUTCRES.RESULT_ID = RES.RESULT_ID
Columns
Name |
OUTCOME_ID |
RESULT_ID |
OUTCOME_SHORT_DESC |
RESULT_SHORT_DESC |