/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 vote385 views1 answer
Change date format in oracle query
SQL
17 votes372 views4 answers
Show tables sql server
SQL
3 votes367 views2 answers
Search text in all sql server stored procedure
SQL
0 vote359 views3 answers
How to increase size of column in sql
SQL
0 vote337 views1 answer
Postgresql alter column nullable
SQL
0 vote377 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote375 views1 answer
Mysql select from outside
SQL
21 votes362 views4 answers
Add column mssql
SQL
1 vote340 views2 answers
Create a unqie constraint mysql
SQL
2 votes341 views1 answer
Oracle convert run_duration to number
SQL