/SQL/Sql missing records from another table

Sql missing records from another table

-- 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 vote316 views2 answers
End mysql command
SQL
1 vote348 views2 answers
Postgres select from last 3 months
SQL
3 votes360 views3 answers
Postgresql random number
SQL
4 votes321 views1 answer
Oracle user tables
SQL
0 vote342 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote343 views1 answer
How to check event scheduler status mysql
SQL
0 vote345 views1 answer
Oracle webcenter content search enginer
SQL
1 vote363 views1 answer
Convert to hexadecimal sql
SQL
0 vote334 views1 answer
Populate db from command line postgres
SQL
11 votes371 views1 answer
Oracle export view ddl
SQL