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

19 votes139 views6 answers
Laravel sql query
SQL
0 vote149 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
17 votes185 views2 answers
How to assign date field for table in mysql
SQL
0 vote139 views1 answer
Returning with sqlalchemy
SQL
0 vote137 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
4 votes147 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote184 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote153 views1 answer
Select new table sql
SQL
21 votes147 views4 answers
Oracle add column
SQL
1 vote128 views1 answer
Sql Split string function
SQL