select a.name, a.vorname, t.telnum from adressen a left join telefon t on a.id = t.adr_id where isnull(telnum)