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 vote328 views1 answer
How to close external sql connection in laravel
SQL
0 vote355 views1 answer
Postgres regex word boundary
SQL
9 votes333 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote328 views3 answers
Group_concat sql server
SQL
8 votes344 views10 answers
Sql
SQL
1 vote360 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote356 views1 answer
Psql get table data types
SQL
3 votes372 views1 answer
Laravel paginate raw sql
SQL
0 vote362 views1 answer
Min:sec datediff mssql
SQL
0 vote339 views1 answer
Sqlite explain plan
SQL