SELECT a.DEAL_TYPE, a.DEAL_SUBTYPE, a.PRODUCT_TYPE, b.PRODUCT_DESC from XTR_TY_SUB_PRD_COMBIN_V a, XTR_PRODUCT_TYPES_V b where a.DEAL_TYPE = b.DEAL_TYPE and a.PRODUCT_TYPE = b.PRODUCT_TYPE
View Text - HTML Formatted
SELECT A.DEAL_TYPE , A.DEAL_SUBTYPE , A.PRODUCT_TYPE , B.PRODUCT_DESC FROM XTR_TY_SUB_PRD_COMBIN_V A , XTR_PRODUCT_TYPES_V B WHERE A.DEAL_TYPE = B.DEAL_TYPE AND A.PRODUCT_TYPE = B.PRODUCT_TYPE