SELECT a.enty_attr_val_id, a.entity, a.entity_id, a.attribute_id, b.name, b.description, a.enabled_flag, a.score, a.attr_value from pv_enty_attr_values a, pv_attributes_vl b WHERE a.attribute_id = b.attribute_id
View Text - HTML Formatted
SELECT A.ENTY_ATTR_VAL_ID , A.ENTITY , A.ENTITY_ID , A.ATTRIBUTE_ID , B.NAME , B.DESCRIPTION , A.ENABLED_FLAG , A.SCORE , A.ATTR_VALUE FROM PV_ENTY_ATTR_VALUES A , PV_ATTRIBUTES_VL B WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID