/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

8 votes245 views2 answers
Mysql get first x characters
SQL
0 vote228 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes231 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote234 views1 answer
Merge clause with inner join
SQL
0 vote243 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote226 views1 answer
Power query datetime to date
SQL
0 vote237 views1 answer
Mssql check if date is greater than today
SQL
15 votes247 views5 answers
If null mysql
SQL
12 votes235 views4 answers
Mysql version query
SQL
0 vote233 views1 answer
Get number of tables in database sql
SQL