DELETE FROM (ma) AA WHERE AA.telno in (SELECT telno FROM NEWADSL)MartinaJ
>ma=JUSTSTEM(thisform.text1.value) >USE (ma) >COUNT TO thisform.text3.value >total = Val(THISFORM.TEXT2.VALUE) >RAND(-1) >INDEX ON RAND() TO SYS(2023)+'\RANDOM' >COPY TO NEWADSL NEXT total >SET INDEX TO >ERASE SYS(2023)+'\RANDOM' > >DELETE FROM (ma) WHERE &ma..telno in (SELECT telno FROM NEWADSL)&&syntax error >SET DELETED ON >