how to check which record does not exists in one table to another table in sql server?

Asked 7 years ago Updated 7 years ago 972 views

sql programming

for example we have two table like table1 and table2 . i want to select all table1 record which does not exists in table2.

asked by Anonymous User , modified by Anonymous User in technology

1 Answer

Use not exists keyword to select first table record which does not exist in the second table.

Here, is the Query string

SELECT t1.name FROM

table1 t1

WHERE NOT EXISTS (

SELECT * FROM table2 t2

WHERE t2.id = t1.id)