/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

1 vote186 views1 answer
Oracle lock user
SQL
0 vote206 views1 answer
Mysql procedure between two tables
SQL
1 vote209 views1 answer
Create temporal table in sql
SQL
0 vote219 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
5 votes252 views3 answers
Sql limit offset
SQL
1 vote333 views1 answer
Concat first name and last name in mysql
SQL
0 vote267 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote208 views1 answer
Phpmyadmin mysql conflict
SQL
2 votes163 views5 answers
Alter table primary key postgresql
SQL
15 votes206 views5 answers
If null mysql
SQL