/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 vote264 views1 answer
How to add auto increment primary key
SQL
0 vote192 views1 answer
Implicit inner join table alias
SQL
0 vote183 views3 answers
Get free card roblox
SQL
8 votes204 views1 answer
Declare table variable sql server
SQL
1 vote176 views1 answer
Jooq convert using gbk
SQL
-1 vote173 views1 answer
Extract Data from SQL Server into XML Format
SQL
4 votes183 views2 answers
How to count items with same name in sql
SQL
0 vote188 views1 answer
Oracle get running queries
SQL
0 vote281 views3 answers
Get count of null in column sql
SQL
0 vote177 views1 answer
Uuid sqlalcomany
SQL