get all rows in table that are not in another table sql code example

Example: sql select where id not exists in another table

where ID not in(select ID from T2 where HISTORY_FLG!=1)