O! I see what You want now :o)))
try:
SELECT 38
ZAP
alias38 = ALIAS()
SELECT 6
mcode = LCode
msec = Sec
alias6 = ALIAS()
INSERT INTO (alias38) (scode, lcode, sec, nostudent);
SELECT DISTINCT b.scode, b.lcode, b.sec,;
(SELECT COUNT(*) FROM (alias6) WHERE admtd=1 and lcode = b.Lcode .and. sec = B.sec);
FROM (alias6) B;
GROUP BY Scode,Lcode,Sec;
WHERE admtd=1
sele 38
...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
