/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

7 votes196 views2 answers
Sql server drop temp table if exists
SQL
0 vote187 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote182 views1 answer
Mysql set column equal to another automatic
SQL
0 vote196 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote188 views1 answer
Call object contructor and call methods of object
SQL
0 vote217 views1 answer
Postgresql concat string with separator
SQL
1 vote153 views1 answer
Mysql show attributes of a table
SQL
1 vote182 views1 answer
Oracle db create new schema
SQL
0 vote138 views1 answer
Mysqli or pdo
SQL
17 votes192 views3 answers
How to change a collumn name in sql
SQL