hi,
thank you , same error syntax error
>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
>>