SELECT DISTINCT E.ITEM_CATALOG_GROUP_ID , V.ELEMENT_NAME /** V.ELEMENT_VALUE **/ FROM MTL_DESCR_ELEMENT_VALUES V , MTL_DESCRIPTIVE_ELEMENTS E WHERE V.ELEMENT_NAME = E.ELEMENT_NAME
View Text - HTML Formatted
SELECT DISTINCT E.ITEM_CATALOG_GROUP_ID , V.ELEMENT_NAME /** V.ELEMENT_VALUE **/ FROM MTL_DESCR_ELEMENT_VALUES V , MTL_DESCRIPTIVE_ELEMENTS E WHERE V.ELEMENT_NAME = E.ELEMENT_NAME