select id that doesn't exist in a table code example Example: sql select where id not exists in another table where ID not in(select ID from T2 where HISTORY_FLG!=1)