Solved Delete Query from Table A If found in Table B (1 Viewer)

Number11

Member
Local time
Today, 11:52
Joined
Jan 29, 2020
Messages
607
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 :(

1634132292637.png
 

CJ_London

Super Moderator
Staff member
Local time
Today, 11:52
Joined
Feb 19, 2013
Messages
16,553
try
Code:
DELETE
FROM TableA
WHERE Exists(SELECT * FROM TableB WHERE  TableA.OrderNo = TableB.OrderNo
AND TableA.OrderDate= TableB.OrderDate)
 

Number11

Member
Local time
Today, 11:52
Joined
Jan 29, 2020
Messages
607
try
Code:
DELETE
FROM TableA
WHERE Exists(SELECT * FROM TableB WHERE  TableA.OrderNo = TableB.OrderNo
AND TableA.OrderDate= TableB.OrderDate)
no didnt work now i get

1634133050178.png
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:52
Joined
Oct 29, 2018
Messages
21,357
Is Table B an archive table? How many records are in it? How many records in Table A?
 

Users who are viewing this thread

Top Bottom