Sql values not in another table

-- 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 vote241 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
1 vote350 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote226 views1 answer
Pl sql constraint user function
SQL
0 vote227 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
6 votes263 views2 answers
Install psql mac
SQL
1 vote234 views1 answer
Create table tablename as select * from tablename
SQL
0 vote235 views1 answer
Sql developer search all packages for text
SQL
0 vote232 views1 answer
Copy Table from SQL to CSV
SQL
2 votes231 views1 answer
How to find table table in stored procedure sql server
SQL
3 votes214 views1 answer
V$session not found in oracle
SQL