Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH a AS (
- SELECT CODE_VALUE AS CODE, DISPLAY AS DESCRIPTION, CODE_SET FROM CODE_VALUE
- WHERE CODE_SET = 69 AND ACTIVE_IND = 1
- UNION ALL
- SELECT CODE_VALUE AS CODE, DISPLAY AS DESCRIPTION, CODE_SET FROM CODE_VALUE
- WHERE CODE_SET = 71 AND ACTIVE_IND = 1
- )
- SELECT C1.CODE, C1.DESCRIPTION, C2.CODE, C2.DESCRIPTION
- FROM a C1
- CROSS JOIN a C2
- WHERE C1.CODE_SET = 69 AND C2.CODE_SET = 71
- --Alternate Combo: WHERE C1.CODE < C2.CODE
- ORDER BY C1.CODE, C2.CODE;
Advertisement