What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-29 10:56:06
sql find missing values between two tables
-- 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 -
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
Shaples
+5
Tranquilled
+5
Kozuch
+5
Big D Rock
+5
The 313137
+5
Toby Stewart
+5
Moez
+5
Stelle
+5
Kathrin
+5
Moradnejad
+5
Tony_Henrich
+5