>>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;
>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.
If it's not broken, fix it until it is.
My Blog