SELECT DISTINCT p.name AS Professor, s.name AS Student FROM professoren p, vorlesungen v, hoeren h, studenten s WHERE v.gelesenvon = p.persnr and h.vorlnr = v.vorlnr and h.matrnr = s.matrnr ORDER BY p.name, s.name