Hi Mohammed,

Try this

DELETE FROM (ma) AA WHERE AA.telno in (SELECT telno FROM NEWADSL)

MartinaJ

>hi all,
>
>thanks for help.
>i get error message syntax error at this line,
>some tims it works??
>DELETE FROM (ma) WHERE &ma..telno in (SELECT telno FROM NEWADSL)&&syntax error
>
>i try as..
>*DELETE FROM (ma) WHERE EXISTS(SELECT * FROM NEWADSL WHERE &ma..telno==newadsl.telno)&&& Function name is missing
>
>
>

>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
>