/SQL/Sql find missing values between two tables

Sql find missing values between two tables

-- 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

0 vote331 views1 answer
Sql server delete records with specific date
SQL
0 vote365 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote337 views1 answer
Heidisql check how much space a row
SQL
0 vote323 views1 answer
Nueva tabla mysql
SQL
0 vote336 views1 answer
Oracle string substitution
SQL
1 vote328 views1 answer
Mysql random limit 1
SQL
0 vote320 views2 answers
Mysql slave status
SQL
0 vote340 views1 answer
Sqlite to csv statement
SQL
1 vote379 views1 answer
Oracle see column type
SQL
0 vote343 views1 answer
Sql count null values in all columns
SQL