/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 vote190 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote238 views1 answer
Mysql date equals to current_date plus days
SQL
8 votes199 views2 answers
Alert table name mysql
SQL
0 vote208 views1 answer
Mysql not defined
SQL
0 vote262 views1 answer
Mysql sum per week
SQL
2 votes189 views1 answer
Oracle cpu per session
SQL
5 votes175 views2 answers
Create table
SQL
1 vote320 views1 answer
Mysql breakline on string
SQL
6 votes211 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote196 views1 answer
Sql row number in result set
SQL