Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql select where id not exists in another table

where ID not in(select ID from T2 where HISTORY_FLG!=1)
 
PREVIOUS NEXT
Tagged: #sql #select #id #exists #table
ADD COMMENT
Topic
Name
8+5 =