how to find out an id which does not exits in other table in 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)
where ID not in(select ID from T2 where HISTORY_FLG!=1)