how to do a SQL Join that returns the rows that are not present in my table 2

Question

I want to run a query between my two tables and returns the results to me the lines that are not present in my table 2

score 2 · Accepted Answer · answered Apr 12 '11 at 08:04

2

select * from table1 
         left join table2 
         on table1.id=table2.id 
         where table2.id is null

answered Apr 12 '11 at 08:04

Shakti Singh

sorry, the same answer at the same time. Do you want me to delete mine? – Marco Apr 12 '11 at 08:05
@Macro: What for sorry? No problem. This is natural on SO – Shakti Singh Apr 12 '11 at 08:07

score 0 · Answer 2 · edited May 23 '17 at 12:04

0

Look at this post.
I copied the code:

select * from A left join B on A.x=B.y where B.y is null;

edited May 23 '17 at 12:04

Community

answered Apr 12 '11 at 08:04

Marco

score 0 · Answer 3 · answered Apr 12 '11 at 08:05

0

Should be something like this:

SELECT * FROM table2 WHERE table1_id NOT IN (SELECT id FROM table1)

answered Apr 12 '11 at 08:05

Richard Tuin

3 Answers3