sql select where id not exists in another table
snippet in sql

sql select where id not exists in another table

user9384

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