SQL query to find record with ID not in another table

October 24, 2022 by Tarik

Try this

SELECT ID, Name 
FROM   Table1 
WHERE  ID NOT IN (SELECT ID FROM Table2)