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

1 vote174 views1 answer
Ef core 5.0 usesqlserver not found
SQL
1 vote175 views1 answer
How to open closed port mysql in ubuntu
SQL
5 votes209 views2 answers
Mysql dump mysql db cli
SQL
4 votes174 views1 answer
Change nls_date_format
SQL
0 vote272 views1 answer
How to get table current identity value in sql server
SQL
0 vote173 views1 answer
Mysql docker image for macbook m1
SQL
0 vote186 views1 answer
SQL Error 1040 : Too many connections
SQL
2 votes233 views2 answers
Postgres set user as superuser
SQL
0 vote188 views1 answer
Mysql get nth highest
SQL
0 vote185 views1 answer
Postgres list all triggers
SQL