/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 votes418 views1 answer
Mysql cli connect with password
SQL
0 vote345 views1 answer
Oracle exchange partition
SQL
2 votes411 views1 answer
Creating a view SQL
SQL
0 vote346 views1 answer
Mysqldump don't drop table
SQL
0 vote372 views1 answer
Convert multiple columns to ROws in sql server
SQL
7 votes432 views2 answers
Drop index oracle
SQL
1 vote350 views1 answer
Set autoincrement to 0
SQL
0 vote365 views1 answer
Closure in sql
SQL
0 vote364 views1 answer
With_for_update sqlalchemy
SQL
0 vote338 views2 answers
Sql drop view if exists
SQL