SELECT estatetype.name as ename, estatetype.id, items.estatetype FROM items INNER JOIN estatetype ON estatetype.id=items.estatetype