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 vote309 views1 answer
Sql query to select even numbers
SQL
0 vote253 views3 answers
Sql delete all except
SQL
12 votes255 views4 answers
Mysql version
SQL
0 vote218 views1 answer
Create duplicate table in postgresql
SQL
-1 vote271 views5 answers
Convert sql to linq query online
SQL
0 vote264 views1 answer
Select row with latest date mysql
SQL
0 vote277 views1 answer
Oracle 11g forget password
SQL
0 vote239 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote257 views3 answers
How to truncate table with foreign key constraint
SQL
3 votes254 views2 answers
Host is not allowed to connect to this mysql server
SQL