What is wrong with this SQL?

[Joe M.]

I am trying to delete all the data from 3 tables using this SQL in a query:

DELETE WBS_List_PRPS.*
FROM WBS_List_PRPS
DELETE WBS_Dates_PRTE.*
FROM WBS_Dates_PRTE
DELETE MWO_Header_ZIW39.*
FROM MWO_Header_ZIW39;

When I try to save I get syntax error in FROM clause. If I only try to
delete from one table:

DELETE MWO_Header_ZIW39.*
FROM MWO_Header_ZIW39;

Then it works fine. What am I missing?

Thanks!
Joe M.

 

[Daryl S]

You can only delete records from one table at a time. You can run the three
delete queries separately.