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
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
|
|
|