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-09-29 06:36:02
mysql find missing values
-- 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
Best helpers
Tim7823
+5
Bumba Clat
+5
Relle
+5
Stephen Raj
+5
Bryzzeij
+5
Jihed gasmi
+5
Fame Whiz
+5
Xiaoyaolnm
+5
Dee doo
+5