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

7 votes160 views2 answers
Where keyword sql
SQL
1 vote150 views2 answers
Extract weekday from date in sql
SQL
0 vote143 views1 answer
Renommer table sql
SQL
18 votes150 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
3 votes149 views3 answers
Update join
SQL
0 vote217 views1 answer
Mysql grant access to one database
SQL
6 votes155 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote140 views1 answer
Oracle split string
SQL
0 vote183 views3 answers
Mysql CAST(amount as float)
SQL
0 vote147 views1 answer
Mariadb errno 121
SQL