Delete Query with inner join

Gismo · Jun 7, 2018

Hi,

I am trying to delete records from my history table (TBL A) if value in my list table (TBL B) has been met but I get a "Could not delete from specified tables" error.. below is my code.

Code:

DELETE [Aircraft List].Active, [SB-AD History].*
FROM [SB-AD History] INNER JOIN [Aircraft List] 
ON [SB-AD History].[Aircraft Registration] = [Aircraft List].[Aircraft Registration]
WHERE ((([Aircraft List].Active)=False));

isladogs · Jun 7, 2018

You may have a read only query
Try this so it only deletes unique records:

Code:

DELETE DISTINCTROW [Aircraft List].Active, [SB-AD History].*
FROM [SB-AD History] INNER JOIN [Aircraft List] 
ON [SB-AD History].[Aircraft Registration] = [Aircraft List].[Aircraft Registration]
WHERE ((([Aircraft List].Active)=False));

arnelgp · Jun 7, 2018

DELETE [SB-AD History].*
FROM [SB-AD History] WHERE [Aircraft Registration] In (Select T1.[Aircraft Registration] From [Aircraft List] as T1 Where T1.Active=False)

Delete Query with inner join

Gismo

Registered User.

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread