/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

9 votes122 views3 answers
Where clause sql
SQL
0 vote130 views1 answer
Postgresql port 5432 not open
SQL
1 vote107 views1 answer
Mysql remove last empty newline
SQL
0 vote103 views1 answer
Concatenate columns in table
SQL
10 votes109 views4 answers
Primary key sql
SQL
0 vote102 views1 answer
Sql developer export connections
SQL
0 vote115 views2 answers
Jsonb
SQL
3 votes129 views3 answers
Sql current year
SQL
4 votes107 views3 answers
How to describe a table in sqlite3
SQL
1 vote128 views3 answers
Postgresql get difference between two dates
SQL