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

5 votes120 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote94 views2 answers
Delete the last item in a table sql
SQL
0 vote128 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
1 vote138 views1 answer
Mysql select and count left join
SQL
3 votes130 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote125 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
10 votes131 views2 answers
Show tables in schema oracle
SQL
1 vote145 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes132 views1 answer
Postgresql drop primary key constraint
SQL
0 vote136 views2 answers
Mysql missin expression near on
SQL