/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 vote114 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote113 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
7 votes140 views1 answer
Oracle alter sequence restart start with
SQL
0 vote112 views1 answer
Order by ip address sql
SQL
1 vote116 views1 answer
Python escape mysql
SQL
8 votes118 views1 answer
Today minus 15 days postgresql
SQL
4 votes123 views2 answers
Oracle unlock user
SQL
0 vote120 views3 answers
Mysql keyword search
SQL
0 vote123 views1 answer
Placements hackerrank solution
SQL
0 vote117 views1 answer
Sql date d'aujourd'hui
SQL