What is wrong with this SQL?

  • Thread starter Thread starter Joe M.
  • Start date Start date
J

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.
 
You can only delete records from one table at a time. You can run the three
delete queries separately.
 
Back
Top