/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

1 vote144 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
3 votes129 views1 answer
Mysql insert on dupèlicate
SQL
0 vote128 views1 answer
Vowels in sql
SQL
3 votes142 views5 answers
Sql select
SQL
0 vote128 views1 answer
Mysql grant all on all databases
SQL
10 votes157 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote136 views1 answer
Sql doesn't contain
SQL
5 votes138 views1 answer
Sql integer to serial
SQL
4 votes124 views2 answers
Sql server date now
SQL
1 vote146 views1 answer
Oracle create index if not exists
SQL