What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-26 05:10:16
sql values not in another table
-- Find missing t1 values in t2 (based on 'id' field) SELECT * FROM t1 WHERE t1.id NOT IN (SELECT id FROM t2); -- or SELECT * FROM t1 WHERE NOT exists ( SELECT NULL FROM t2 WHERE t2.id = t1.id ); -- or SELECT t1.* FROM t1 LEFT OUTER JOIN t2 ON t2.id =... Add solution -
SQL 2021-10-15 01:57:11
sql missing records from another table
-- Returns missing my_table1 ID in my_table2 SELECT DISTINCT t1.* FROM my_table t1 LEFT OUTER JOIN my_table2 t2 ON t1.ID = t2.ID WHERE t2.ID is null; -- Or: SELECT t1.* FROM my_table1 t1 WHERE NOT EXISTS (SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5