SELECT A.id,A.title as ANACAT_TITLE,B.title AS ALTKAT_TITLE from anacat A LEFT JOIN altkategori B ON (B.ustkategori=anacat.id)