/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

3 votes267 views1 answer
Insert into table from another table mysql
SQL
4 votes294 views3 answers
Is not null sql
SQL
1 vote281 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote293 views1 answer
Frename oracle
SQL
4 votes315 views6 answers
List all tables in postgres
SQL
7 votes289 views1 answer
Sql limit decimal places
SQL
10 votes301 views4 answers
Drop primary key
SQL
1 vote267 views1 answer
Sql get all columns from one table but one from another inner join
SQL
6 votes281 views1 answer
Check Table Exists
SQL
0 vote309 views2 answers
Unique key
SQL