SELECT MFG_ORG_CD,TO_CRNCY_CD,FROM_CRNCY_CD,DAY_CD,EXCHNG_RATE FROM DDR_B_CRNCY_EXCHNG_RATE UNION SELECT MFG_ORG_CD ,CRNCY_CD ,CRNCY_CD ,'19000101' AS DAY_CD ,1 AS EXCHNG_RATE FROM DDR_R_CRNCY
View Text - HTML Formatted
SELECT MFG_ORG_CD , TO_CRNCY_CD , FROM_CRNCY_CD , DAY_CD , EXCHNG_RATE FROM DDR_B_CRNCY_EXCHNG_RATE UNION SELECT MFG_ORG_CD , CRNCY_CD , CRNCY_CD , '19000101' AS DAY_CD , 1 AS EXCHNG_RATE FROM DDR_R_CRNCY