CODEWITHSUNDEEP
mysqljoin
mcgrailm
mcgrailm

Reputation: 17640

Finding unique emails across two tables

I have two tables one each with email address. I want all emails from table a that are not in table b.

Here is my query, it seems to be hanging. I must have missed something..

SELECT c.Field_23_4306 AS email, c.Field_25_9341, c.Field_26_1838, c.Field_40_7355
FROM FORM_7 c
LEFT JOIN bounceback b ON c.Field_23_4306 = b.email
WHERE c.Field_23_4306 LIKE "%@%"

What did I do wrong?

Upvotes: 0

Views: 38

Answers (1)

Axel Amthor
Axel Amthor

Reputation: 11096

select a.mail from a where not exists (select 1 from b where a.mail = b.mail)

Upvotes: 2

Related Questions