Solved Delete Query from Table A If found in Table B

[Number11]

Hi,

I need to create a query that will delete all records within TableA where they are present in TableB

The Matching Fields I have

OrderNo
OrderDate

DELETE FROM TableA
INNER JOIN TableB
ON TableA.OrderNo = TableB.OrderNo
AND TableA.OrderDate= TableB.OrderDate

however doesn't work

 

[CJ_London]

try

DELETE
FROM TableA
WHERE Exists(SELECT * FROM TableB WHERE  TableA.OrderNo = TableB.OrderNo
AND TableA.OrderDate= TableB.OrderDate)

 

[Number11]

try

DELETE
FROM TableA
WHERE Exists(SELECT * FROM TableB WHERE  TableA.OrderNo = TableB.OrderNo
AND TableA.OrderDate= TableB.OrderDate)

no didnt work now i get

 

[CJ_London]

try putting a * after DELETE

DELETE *

 

[theDBguy]

Is Table B an archive table? How many records are in it? How many records in Table A?

 

[Number11]

try putting a * after DELETE

DELETE *

yes that worked thanks