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

0 vote295 views1 answer
Download mysql database to excel in android studio
SQL
0 vote282 views1 answer
Mysql workbench search all tables
SQL
12 votes360 views4 answers
How to drop all tables in postgresql
SQL
19 votes302 views2 answers
Mysql add column after another
SQL
6 votes292 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote341 views2 answers
Mysql dump database tables only
SQL
1 vote319 views1 answer
Search for replace in mysql
SQL
0 vote328 views1 answer
Postgres can integer fields be negative
SQL
24 votes324 views6 answers
Replace mysql
SQL
0 vote328 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL