Solved

deleting records  from a table based on the fields of another table ms sql

Posted on 2011-09-27
1
231 Views
Last Modified: 2012-05-12
I have a table1 with field1 and a table2 with field2

I want to delete all records in table1  that do not have a match in table 2 (if john is in table1 and not in table2 I want it deleted) I have done it in very complicated ways using left joins, temprary tables.. but there must be an easier way
0
Comment
Question by:robrodp
1 Comment
 
LVL 9

Accepted Solution

by:
edlunad earned 500 total points
ID: 36713906
Try this...

DELETE FROM Table1
WHERE Field1 NOT IN 
    (SELECT Field2 
     FROM Table2)

Open in new window

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

756 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