hi all,
any idea.
my table has field (flag) i insert 1,2...3 you can see 10 records have flage 1,20 records has flage 2 etc....
i need to get 5 records from evry flag to insert to anther table hase the same filds.

i'll try with code but the gode get all records

SELECT 1
USE aliq
m.no=no
m.nam=nam
DO WHILE .t. and no=m.no 
skip

IF m.no<>no 
 m.no=no
 
IF EOF()
EXIT
ENDIF
endif
enddo

thanks
m.qasem