CODE EXAMPLE FOR SQL

how get data from database if id not found then search another column

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