SELECT distinct a.DEAL_TYPE, b.USER_DEAL_SUBTYPE, b.NAME from XTR_TY_SUB_PRD_COMBIN_V a, XTR_DEAL_SUBTYPES b WHERE a.DEAL_TYPE = b.DEAL_TYPE and a.DEAL_SUBTYPE = b.DEAL_SUBTYPE
View Text - HTML Formatted
SELECT DISTINCT A.DEAL_TYPE , B.USER_DEAL_SUBTYPE , B.NAME FROM XTR_TY_SUB_PRD_COMBIN_V A , XTR_DEAL_SUBTYPES B WHERE A.DEAL_TYPE = B.DEAL_TYPE AND A.DEAL_SUBTYPE = B.DEAL_SUBTYPE