/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 votes108 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote180 views1 answer
Install ms sql server management studio
SQL
3 votes99 views1 answer
Sql select all
SQL
0 vote94 views1 answer
Metada in sql
SQL
8 votes112 views1 answer
Show mysql user table
SQL
0 vote95 views1 answer
Save single sql query result boolean spring boot
SQL
2 votes104 views1 answer
Mysql last 7 days including today
SQL
1 vote185 views2 answers
Postgres select from last 3 months
SQL
3 votes112 views1 answer
Sql cast to integer
SQL
0 vote171 views1 answer
Check user sql password from command line
SQL