Answers for "sql select record from a table what doenst exist another"

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 "sql select record from a table what doenst exist another"

Code answers related to "SQL"

Browse Popular Code Answers by Language