/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

2 votes185 views1 answer
Mysql create user with remote access
SQL
1 vote205 views3 answers
Mysql parse int
SQL
2 votes190 views2 answers
Postgres trigger insert into another table
SQL
0 vote183 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote189 views1 answer
Mysql query problems and solutions
SQL
0 vote213 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
6 votes198 views3 answers
Update with inner join postgres
SQL
0 vote235 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote204 views1 answer
Postgresql inheritance
SQL
0 vote183 views1 answer
How to get data between a last week in mysql
SQL