/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 vote170 views1 answer
The local psql command could not be located
SQL
0 vote163 views1 answer
How to add session data into mysql database from button
SQL
7 votes203 views1 answer
Oracle alter sequence restart start with
SQL
0 vote196 views1 answer
Look at running processes redshift
SQL
31 votes179 views2 answers
Grant all priviledges to mysql user
SQL
0 vote171 views1 answer
Mysql identified by syntax error
SQL
0 vote168 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote196 views1 answer
Hue hive UploadingTextFiletoHive
SQL
1 vote182 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote182 views1 answer
Postgresql cast as year and month from timestamp
SQL