/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 vote217 views1 answer
To Create directory
SQL
1 vote202 views1 answer
Add time to date sql
SQL
3 votes209 views1 answer
Oracle sleep
SQL
7 votes194 views3 answers
Add primary key to database sql
SQL
7 votes212 views2 answers
Mysql default value
SQL
1 vote207 views2 answers
Update with inner join sql server
SQL
16 votes185 views3 answers
Order by sql query
SQL
0 vote192 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
14 votes200 views3 answers
Delete all records from table except sql
SQL
0 vote218 views1 answer
Sql server get date of previous sunday
SQL