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 ...]]
>
>