How to select all records from one table that do not exist in another table

Question

Here is my two table as:

table1 (id, name)
table2 (id, name)

Query:

SELECT name   
FROM table2  

Answer 1

Hello @kartik,

You can either do like this:

SELECT name
FROM table2
WHERE name NOT IN
    (SELECT name 
     FROM table1)

or

SELECT name 
FROM table2 
WHERE NOT EXISTS 
    (SELECT * 
     FROM table1 
     WHERE table1.name = table2.name)

Hope it helps!!

Thank you!

Get a further understanding from the Microsoft SQL course

Comments

Thank a lot! I was searching this from 3 Days

---

Thanks, its working.