/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

0 vote121 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote124 views1 answer
Where name ends in SQL
SQL
0 vote124 views1 answer
Trigger stock phpmyadmin output message
SQL
37 votes119 views3 answers
Postgresql insert column
SQL
0 vote119 views1 answer
Nueva tabla mysql
SQL
3 votes121 views1 answer
Sql multi column index performance
SQL
5 votes117 views3 answers
Truncate function in sql oracle
SQL
6 votes129 views2 answers
How to get yesterday date in mysql
SQL
0 vote122 views1 answer
Sql not exists
SQL
0 vote135 views1 answer
Why do we need data structure in sql
SQL