/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 vote115 views1 answer
Sql reverse order of results
SQL
0 vote65 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote111 views1 answer
Apex for oracle 11g
SQL
1 vote137 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote100 views2 answers
How to start postgresql laravel
SQL
0 vote110 views1 answer
Sql inserted
SQL
0 vote129 views3 answers
Insert query in ci
SQL
6 votes149 views2 answers
Subtr Oracle ?
SQL
5 votes105 views1 answer
Update sql user password
SQL
0 vote102 views4 answers
Mysql count table rows
SQL