Jim,

I think you may be thinking of the VFP DELETE and the FOR clause.

>You are right, thanks for the correction.
>
>
>>>FROM clause is for VFP syntax not SQL syntax, in SQL it is a WHERE clause. There are two DELETE commands in VFP, one is VFP DELETE and it has a FROM clause the other is SQL DELETE and it has a WHERE clause. You are getting them mixed up.
>>
>>Jim, from Help:
>>
>>

>>DELETE - SQL Command
>>
>>DELETE [Target] FROM [FORCE] Table_List [[, Table_List ...] | [JOIN [ Table_List]]]
>>   [WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]
>>
>>