/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

20 votes163 views4 answers
How to find average in sql
SQL
3 votes129 views1 answer
Fk in insert mysql
SQL
0 vote124 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
1 vote113 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote131 views1 answer
Neo4j command to run script file
SQL
1 vote156 views1 answer
Drop colum oracle 18c
SQL
0 vote125 views1 answer
Search db for table name
SQL
0 vote127 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote159 views2 answers
CREATE OR REPLACE FUNCTION
SQL
4 votes118 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL