hi,

it works as..

DELETE FROM (ma) WHERE EXISTS(SELECT * FROM newadsl WHERE telno=&ma..telno)

>Try
>
>

delete from (m.ma) aa inner join NEWADSL new on aa.telNo = New.TelNo

>
>See http://msdn2.microsoft.com/en-us/library/6kt4x6zx(VS.80).aspx
>
>
>>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
>>