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

15 votes351 views2 answers
Select Options
SQL
0 vote333 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote361 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote372 views1 answer
Copy data from one postgres container to another
SQL
11 votes338 views2 answers
Docker create postgres db
SQL
0 vote346 views1 answer
Soql last week
SQL
2 votes373 views2 answers
Storing timezones in postgres
SQL
1 vote374 views1 answer
Oracle difference between two dates in years
SQL
22 votes463 views4 answers
Mysql format date
SQL
-1 vote380 views1 answer
Mysql faster insert
SQL