SELECT ID , VALUE , SRID FROM (SELECT P.REQUEST_ID ID , P.REQUEST_ID VALUE , SET_REQUEST_ID SRID FROM BIS_RS_PROG_RUN_HISTORY P UNION SELECT S.REQUEST_ID ID , S.REQUEST_ID VALUE , SET_REQUEST_ID SRID FROM BIS_RS_STAGE_RUN_HISTORY S UNION SELECT REQUEST_ID ID , REQUEST_ID VALUE , REQUEST_ID SRID FROM BIS_RS_RUN_HISTORY)