/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

3 votes150 views3 answers
List columns in table postgres
SQL
0 vote130 views1 answer
USING THE NOT CONDITION IN SQL
SQL
1 vote110 views2 answers
Mysql order by date asc null last
SQL
7 votes132 views1 answer
Sql limit decimal places
SQL
0 vote110 views1 answer
Sql select most frequent value in group
SQL
12 votes114 views2 answers
Delete all nodes neo4j
SQL
0 vote124 views1 answer
Drop index in sql
SQL
0 vote261 views1 answer
Dublicate row sql
SQL
0 vote142 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
13 votes112 views5 answers
Select last row mysql
SQL