Solved

Delete files in one table from another

Posted on 2014-11-13
2
182 Views
Last Modified: 2014-11-13
I have a table of duplicate entries in a Master table. I have saved those I wish to delete in the duplicate table.  How would I go about deleting those in the duplicate table from those in the Master table?
0
Comment
Question by:Serena2345
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40440468
What are the names of the tables, and the names of the primary keys (I assume they are the same between the two)?

Then it is:

Delete Table1.* from Table1
INNER JOIN Table2 ON Table1.PK = Table2.PK;
0
 

Author Closing Comment

by:Serena2345
ID: 40440478
Thx so much
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA Access 2016 syntax 6 44
Top 1 of each supplier 55 57
Visible ppty on rpt 7 7
Microsoft Access Delete all Records from table but Max 2 11
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question