/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 vote196 views1 answer
Window function to forward fill
SQL
-1 vote205 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote190 views1 answer
Get table which have specific columns in mysql
SQL
0 vote236 views1 answer
Sql query to select even numbers
SQL
0 vote179 views1 answer
Rollback to name in sql
SQL
3 votes222 views3 answers
Raw select laravel
SQL
0 vote205 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
1 vote180 views1 answer
Oracle start job
SQL
1 vote187 views2 answers
Rebuild index sql server
SQL
0 vote201 views1 answer
How to export only procedures mysql
SQL