SELECT 38 ZAP alias38 = ALIAS() SELECT 6 mcode = LCode msec = Sec alias6 = ALIAS() INSERT INTO (alias38) (scode, lcode, sec, nostudent); SELECT DISTINCT scode, lcode, sec,; (SELECT COUNT(*) FROM (alias6) WHERE admtd=1 and lcode=mcode.and. sec=msec); FROM (alias6) group by scode,lcode,sec WHERE admtd=1 sele 38 ...