SELECT (select drf.feature_value from igs_da_req_ftrs drf WHERE drf.feature_code = 'RAY' and drf.batch_id = dr.batch_id), (select drf.feature_value from igs_da_req_ftrs drf where drf.feature_code = 'REF' and drf.batch_id = dr.batch_id), (select drf.feature_value from igs_da_req_ftrs drf where drf.feature_code = 'RAI' and drf.batch_id = dr.batch_id), dr.batch_id from igs_da_rqst dr
SELECT (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'RAY'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'REF'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'RAI'
AND DRF.BATCH_ID = DR.BATCH_ID)
, DR.BATCH_ID
FROM IGS_DA_RQST DR
|
|
|