>>Change
>>USE (ma) alias WorkTable
>>
>>to
>>
>>USE (ma) alias WorkTable exclusive
>>
>>I could not figure out what's wrong with the syntax in this line
>>

>>delete from WorkTable inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo

>>
>>I have VFP8, and INNER JOIN is not listed in DELETE-SQL command in Help.
>>
>>Anyway,
>>

>>delete from WorkTable where exists (select * from RecToDelete)

should work in VFP8 as well as in VFP9.
>
>The correct syntax even in VFP 9 is:
>

>delete from WorkTable;
>       from WorkTable;               && Double FROM clause
>inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo
>

>I am not sure if it exists in VFP8.

I see, thanks a lot. Let me re-check VFP9 help online.

It doesn't exist in VFP8, I've checked Help a minute ago.