Sql values not in another table

-- 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

1 vote225 views1 answer
Postgresql update auto_increment value
SQL
0 vote177 views1 answer
Get yesterday date ISO in psql
SQL
1 vote195 views1 answer
Sqlite3 read only
SQL
2 votes188 views1 answer
How to insert string variable into sqlite database
SQL
4 votes206 views1 answer
List tables sqlite
SQL
1 vote178 views1 answer
How to test for sql injection
SQL
0 vote182 views1 answer
Oracle drop default value
SQL
0 vote234 views2 answers
Check if sql temp table exists
SQL
4 votes207 views2 answers
Delete all table oracle
SQL
1 vote188 views1 answer
Mysql show queries running
SQL