Sql missing values

-- Find missing t1 values in t2 (based on 'id' field)
SELECT * FROM t1 WHERE t1.id NOT IN (SELECT id FROM t2);
-- or
SELECT * FROM t1 WHERE NOT exists (
    SELECT NULL FROM t2 WHERE t2.id = t1.id
);
-- or
SELECT t1.* FROM t1 LEFT OUTER JOIN t2 ON t2.id = t1.id WHERE t2.id IS NULL;

Similar codes

2 votes178 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote180 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote162 views1 answer
Reset postgresql password windows
SQL
2 votes138 views2 answers
Mysql user access to database
SQL
0 vote141 views1 answer
Mysql select last 15 minutes
SQL
4 votes134 views1 answer
Select nls_date_format
SQL
22 votes154 views3 answers
Year format in date mysql
SQL
2 votes143 views1 answer
Postgresql add entry to table
SQL
0 vote189 views1 answer
Drop a view in sqlite
SQL
0 vote147 views1 answer
Firebird where
SQL