/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

24 votes321 views5 answers
Sql server insert into select
SQL
3 votes317 views2 answers
Sql random integer
SQL
0 vote260 views1 answer
<script>alert
SQL
0 vote302 views1 answer
Access refused mysql xampp server
SQL
0 vote415 views2 answers
Insert data into multiple tables mysql
SQL
2 votes334 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote342 views2 answers
Mysql trim spaces
SQL
0 vote323 views1 answer
What is default mysql database password in linux
SQL
4 votes338 views2 answers
Mysql delete user if exists
SQL
0 vote324 views3 answers
Average salary in sql
SQL