/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 vote145 views1 answer
Grepper sql workbench download
SQL
0 vote151 views1 answer
Price-colour
SQL
-1 vote152 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote92 views1 answer
Copy table dbeaver
SQL
0 vote164 views2 answers
Port 5432 is already in use mac
SQL
0 vote153 views1 answer
Oracle array
SQL
0 vote152 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote151 views1 answer
Input in mysql
SQL
0 vote153 views1 answer
Set a default value for a column in sqlite
SQL
10 votes163 views1 answer
Oracle dependencies table
SQL