/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

11 votes387 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote344 views1 answer
Mysql group by derived column
SQL
0 vote367 views1 answer
Add column to table with default value plsql
SQL
0 vote377 views1 answer
Oracle plsql sleep
SQL
8 votes398 views2 answers
Between operator
SQL
7 votes377 views1 answer
Mysql iif
SQL
0 vote357 views1 answer
Sql waitfor
SQL
0 vote358 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote360 views1 answer
Qt qsql check if table exist
SQL
13 votes360 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL