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 vote238 views1 answer
Mysql tables max count
SQL
1 vote249 views1 answer
Sql restore backup query
SQL
2 votes229 views1 answer
Oracle sql concatenate results into string
SQL
4 votes233 views1 answer
List tables sqlite
SQL
0 vote257 views1 answer
Grant privileges of databse to user
SQL
0 vote246 views1 answer
Typeorm raw sql
SQL
0 vote247 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
12 votes212 views4 answers
SQL Where
SQL
5 votes240 views1 answer
Sqlite alter table add column
SQL
9 votes228 views3 answers
Where in sql
SQL