/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 vote302 views1 answer
Initcap in sql
SQL
2 votes289 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote305 views1 answer
Oracle list proxy users
SQL
0 vote305 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote317 views1 answer
Duplix print in Smartforms
SQL
-2 votes303 views1 answer
Use of where in left join in mysql
SQL
0 vote298 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote303 views2 answers
Last working day in week date function in sql
SQL
13 votes307 views2 answers
Sql count distinct group by
SQL
3 votes287 views1 answer
Insert into table from another table mysql
SQL