Hi All

I am quite new to programming but I cannot find what is wrong with this SQL.

DELETE Master.Identifier, Master.[Shipment Number], Master.[Shipment Description], Master.[Freight Method], Master.[Route Description], Master.[ASN Number], Master.Supplier, Master.[Port of Despatch], Master.[Country of Despatch], Master.[Delivery Site Warehouse], Master.[Delivery Site Warehouse Description], Master.[Planned Delivery Date to RS UK], Master.[Planned Delivery Date to Port], Master.[Delivery Item], Master.[Article No], Master.[Supplier Article number], Master.[Order Qty], Master.[Order Unit], Master.[Base Qty], Master.[Base Unit], Master.[Net Weight], Master.[Gross Weight], Master.[Weight Unit], Master.Volume, Master.[Volume Unit], Master.[RM Type], Master.[RM Qty], Master.[RM Unit of Measure], Master.[Purchase Order Number], Master.[PO Item Number], Master.ETA, Master.ETD, Master.[Bill or Lading/AWB Number]
FROM Master INNER JOIN [Shipments Completed] ON Master.Identifier = [Shipments Completed].Identifier
WHERE ((([Shipments Completed].ETA)<>" "));


But I get an error saying specify the table containing the value you want to delete.

I look forward to your help in advance.