/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 vote70 views1 answer
Into sql
SQL
0 vote101 views1 answer
How to find top 3 salary in sql
SQL
0 vote111 views1 answer
Sql max min
SQL
1 vote144 views1 answer
Mysql default port
SQL
0 vote106 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote109 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote59 views1 answer
Oracle list all stored procedures
SQL
3 votes111 views1 answer
Make a field auto_increment mysql
SQL
0 vote128 views1 answer
Check if mysql db is used
SQL
2 votes115 views3 answers
3 days back in sql server
SQL