SELECT A.ACCESS_ID, B.STYLE_FORMAT_CODE, B.VARIATION_NUMBER, B.VARIATION_RANK, B.SELECTION_CONDITION FROM JTM_HZ_STYL_FMT_VARIATION_ACC A, HZ_STYLE_FMT_VARIATIONS B WHERE B.STYLE_FORMAT_CODE=A.STYLE_FORMAT_CODE AND B.VARIATION_NUMBER=A.VARIATION_NUMBER AND B.VARIATION_RANK=A.VARIATION_RANK
SELECT A.ACCESS_ID
, B.STYLE_FORMAT_CODE
, B.VARIATION_NUMBER
, B.VARIATION_RANK
, B.SELECTION_CONDITION
FROM JTM_HZ_STYL_FMT_VARIATION_ACC A
, HZ_STYLE_FMT_VARIATIONS B
WHERE B.STYLE_FORMAT_CODE=A.STYLE_FORMAT_CODE
AND B.VARIATION_NUMBER=A.VARIATION_NUMBER
AND B.VARIATION_RANK=A.VARIATION_RANK
|
|
|