/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 vote201 views1 answer
Get first monday of month sql
SQL
0 vote164 views1 answer
Postgresql function ROUND
SQL
0 vote163 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote177 views1 answer
Sql order by number not ordered
SQL
0 vote199 views1 answer
Varchar2 length in oracle
SQL
0 vote151 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
1 vote215 views1 answer
Column with prefix in sql
SQL
0 vote161 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote174 views1 answer
Testing sql queries
SQL
4 votes159 views1 answer
T-sql get duplicate rows
SQL