Sql missing values

-- 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

3 votes147 views1 answer
Increment integer in table sql
SQL
0 vote134 views1 answer
Psql select * from table
SQL
3 votes121 views2 answers
How to start mysql in terminal
SQL
10 votes136 views4 answers
SELECT FROM WHERE
SQL
0 vote131 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote128 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes132 views1 answer
Oracle find unusable indexes
SQL
0 vote122 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote141 views1 answer
Second Step in installing SQL workbench
SQL
1 vote147 views1 answer
Last 24 HOUR data in mysql
SQL