Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Delete files in one table from another

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
Serena2345
Asked:
Serena2345
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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
 
Serena2345Author Commented:
Thx so much
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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