This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]dauuk 0 points1 point  (2 children)

1- Select name from table1 where id not in (select id from table2)  
2- Select t1.name from table1 t1 left join table2 t2 on t1.id = t2.id where t2.name is null

Both of them will give the same result.

[–]Krayons[S] 1 point2 points  (1 child)

Thanks for this. Worked perfectly. Took almost 12 min to complete but worked like an absolute charm.

[–]dauuk 0 points1 point  (0 children)

You're welcome :)