The following delete query SQL statement working just fine on Access 2003 but after convert to Access 2007, received following message

"Specify the table containing the records you want to delete"

DELETE [Promo].*
FROM [Outlet] INNER JOIN [Promo] ON [Outlet].Out = [Promo].Out;

Please help.

Dublin

Hi,

Here is how I would do it:

DELETE * FROM Promo
WHERE Promo.Out IN (SELECT Outlet.Out FROM Outlet)

Simon B.