SELECT R.LAYER_PROVIDER_CODE, R.TP_LAYER_ID, R.RELEASE_ID, R.APPLICATION_SHORT_NAME, R.FILE_PATH, R.FILE_NAME, E.MESSAGE_TEXT FROM VEA_RELEASE_DETAILS R, VEA_EXCEPTIONS E WHERE R.RELEASE_ID = E.RELEASE_ID AND R.LAYER_PROVIDER_CODE = E.LAYER_PROVIDER_CODE
SELECT R.LAYER_PROVIDER_CODE
, R.TP_LAYER_ID
, R.RELEASE_ID
, R.APPLICATION_SHORT_NAME
, R.FILE_PATH
, R.FILE_NAME
, E.MESSAGE_TEXT
FROM VEA_RELEASE_DETAILS R
, VEA_EXCEPTIONS E
WHERE R.RELEASE_ID = E.RELEASE_ID
AND R.LAYER_PROVIDER_CODE = E.LAYER_PROVIDER_CODE
|
|
|