SELECT reares.result_id, reares.reason_id, res.short_description, rea.short_description from jtf_ih_result_reasons reares, jtf_ih_results_vl res, jtf_ih_reasons_vl rea WHERE reares.result_id = res.result_id and reares.reason_id = rea.reason_id
SELECT REARES.RESULT_ID
, REARES.REASON_ID
, RES.SHORT_DESCRIPTION
, REA.SHORT_DESCRIPTION
FROM JTF_IH_RESULT_REASONS REARES
, JTF_IH_RESULTS_VL RES
, JTF_IH_REASONS_VL REA
WHERE REARES.RESULT_ID = RES.RESULT_ID
AND REARES.REASON_ID = REA.REASON_ID
|
|
|