/SQL/Sql find missing values between two tables

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.ID);
-- Or:
SELECT t1.* FROM my_table1 t1 WHERE t1.ID NOT IN 
   (SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.ID);

Similar codes

0 vote210 views1 answer
Define a variable in mysql from select
SQL
0 vote165 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
5 votes274 views2 answers
Add days in oracle sql
SQL
0 vote193 views1 answer
Implizite joins sql
SQL
2 votes190 views1 answer
Postgresql update sequence next value
SQL
19 votes207 views5 answers
Date between in mysql
SQL
3 votes225 views1 answer
Oracle cannot access v$session
SQL
0 vote219 views1 answer
How to see the query of a view in mysql
SQL
1 vote193 views1 answer
Where date = max(date) in sql
SQL
0 vote220 views1 answer
Oracle string length
SQL