/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

2 votes123 views1 answer
Sql create database
SQL
0 vote156 views1 answer
Jooq replace
SQL
15 votes158 views4 answers
Sql update from select
SQL
0 vote133 views1 answer
Sql select rows with different values in one column
SQL
0 vote93 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote148 views4 answers
Rownum in sql
SQL
-1 vote121 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote141 views1 answer
Postgres left join
SQL
0 vote125 views1 answer
Mysql cdn link
SQL
5 votes146 views1 answer
Oracle nls parameters
SQL