/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 votes162 views1 answer
Postgresql change value in column
SQL
5 votes213 views1 answer
Mysql created at yesterdau
SQL
0 vote176 views1 answer
Sql output select
SQL
23 votes172 views4 answers
How to show all users in mysql
SQL
0 vote156 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote159 views1 answer
Postgresql newline character
SQL
0 vote163 views1 answer
Connexion mysql
SQL
0 vote162 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
3 votes186 views1 answer
Oracle function return
SQL
0 vote202 views1 answer
Mariadb change column type
SQL