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

0 vote182 views1 answer
Postgresql create query
SQL
0 vote198 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote172 views1 answer
Mariadb cast to int
SQL
0 vote178 views1 answer
Multiple tricky query in sql server
SQL
9 votes191 views5 answers
Sql limit
SQL
0 vote185 views1 answer
SQL add a totals of differemt rows of the same id
SQL
1 vote287 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote178 views1 answer
Mysql count with two joins
SQL
1 vote237 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
3 votes182 views1 answer
Create a table with an id in mysql
SQL