yes this code giving me 25 records
but your last may be use scan and scan????

SELECT 38
ZAP
alias38 = ALIAS()

SELECT 6

alias6 = ALIAS()


INSERT INTO (alias38) (scode, lcode, sec) SELECT DISTINCT scode, lcode, sec FROM &alias6 GROUP BY scode, lcode, sec

SELECT 38
brows