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 vote345 views1 answer
Create a PostgreSQL user django on mac
SQL
6 votes391 views2 answers
How to copy data in sql
SQL
0 vote368 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote361 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote351 views1 answer
Oracle free up space in tablespace
SQL
3 votes367 views3 answers
Create a view postgres
SQL
0 vote364 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
24 votes343 views4 answers
How to add column sql
SQL
0 vote339 views2 answers
How to see table associated with a schema in sql
SQL
2 votes349 views1 answer
Oracle current date without time
SQL