MS Access SQL - DELETE - TechRepublic
Question
September 21, 2009 at 05:42 AM
martinbullock15

MS Access SQL – DELETE

by martinbullock15 . Updated 16 years, 9 months ago

Hi

I am trying to Delete from one table depending where records match between to tables. I’m using Access 97 due to the type of database

So i have a table with a list of codes and a second table with the list of codes which i want to delete, this is my statement:

DELETE tblProduct.*
FROM tblProduct
WHERE tblProduct.ProductBarcode = tblProduct_SU.ProductBarcode;

From this i get a Parameters box asking my to enter something.

Any help would be very grateful

Thanks in advance

Martin

This discussion is locked

All Comments