Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Delete records based on unmatched records query

I created a unmatched query from two tables. Table A and Table B.  How do I now delete those unmatched records from Table A.
0
mato01
Asked:
mato01
1 Solution
 
mbizupCommented:
DELETE *
FROM TableA
WHERE TableA.ID IN (SELECT ID FROM YourUnmatchedQuery)
0
 
Jeffrey CoachmanCommented:
<No Points wanted>
"Typically", ....but not always, you can open a query in design view and simply click one of the "Action Query" buttons to do things like Delete Records, Append Records, Update Records, ...etc

Design-->Query Tools-->Query Type

JeffCoachman
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now