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

3 votes269 views1 answer
Dbms_scheduler drop_job
SQL
0 vote263 views1 answer
Como hacer un select entre fechas mysql
SQL
3 votes271 views2 answers
Mysql user permission database
SQL
1 vote269 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
50 votes333 views6 answers
Install mysql on ubuntu
SQL
1 vote274 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote268 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
26 votes272 views2 answers
Mysql workbench download
SQL
0 vote264 views3 answers
Group_concat sql server
SQL
1 vote301 views2 answers
Postgresql check privileges on schema
SQL