> Next I tried this one:
>
> SELECT kvvnr, max(lf_sem.semester) AS akt_semester
> FROM lv, lf_sem
> WHERE lv.semester = akt_semester;
>
> Now I got: 'Attribute 'akt_semester' not found'
>
> Is there another way to get what I want?
What about:
SELECT kvvnr FROM lv WHERE semester = (SELECT MAX(semester) FROM lf_sem);
Chris