>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 ...]]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
