/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 vote298 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote312 views1 answer
Transaction database with php
SQL
1 vote303 views1 answer
DATE_SUB postgres
SQL
0 vote324 views1 answer
Firebase sql
SQL
2 votes291 views3 answers
3 days back in sql server
SQL
0 vote287 views1 answer
How to find unique key in sql
SQL
1 vote283 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote315 views1 answer
Oracle check table lock
SQL
1 vote276 views1 answer
Mysqli connect
SQL
3 votes324 views1 answer
Create a table with an id in mysql
SQL