/SQL/Sql missing records from another table

Sql missing records from another table

-- Returns missing my_table1 ID in my_table2 
SELECT DISTINCT t1.* FROM my_table t1
LEFT OUTER JOIN my_table2 t2
ON t1.ID = t2.ID
WHERE t2.ID is null;
-- Or:
SELECT t1.* FROM my_table1 t1 WHERE NOT EXISTS 
   (SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.ID);
-- Or:
SELECT t1.* FROM my_table1 t1 WHERE t1.ID NOT IN 
   (SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.ID);

Similar codes

0 vote340 views1 answer
Import excel to sql
SQL
1 vote322 views1 answer
Mysql select utc time in eastern time
SQL
3 votes350 views3 answers
Remove all spaces from string sql
SQL
0 vote329 views1 answer
Deny select insert update delete sql
SQL
-1 vote381 views1 answer
Window functions in sql
SQL
1 vote336 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote335 views1 answer
Check psql validity function
SQL
0 vote347 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote326 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote384 views2 answers
Postgres isnull
SQL