SELECT alle.user_ID,zuname FROM alle,fagrpuser WHERE user.tag!=0 AND (fachgruppe_ID='13' AND alle.user_ID=fagrpuser.user_ID)
IN
(SELECT alle.user_ID FROM alle,zuteilung where (substr(zuteilung.klname,1,1)>"4" AND jahr="0708" AND alle.user_ID=zuteilung.user_ID))
group by alle.user_ID order by zuname
|