Specify the table containing the records you want to delete in access 2007

[dublinchang]

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

 

[SimonB1978]

Hi,

Here is how I would do it:

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

Simon B.