Answers for "select statement to get rows not in table"

SQL
1

join to find results not in another table

SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL
Posted by: Guest on September-18-2020
1

sql select where id not exists in another table

where ID not in(select ID from T2 where HISTORY_FLG!=1)
Posted by: Guest on May-20-2020

Code answers related to "select statement to get rows not in table"

Code answers related to "SQL"

Browse Popular Code Answers by Language