SELECT DISTINCT a.entity_id, a.value, b.value FROM Table_1 AS a JOIN Table_2 AS b on a.entity_id = b.entity_id WHERE a.attribute_id = x AND b.attribute_id = y
