MySQL: Find values in two tables

I have a list of email addresses of people who no longer wish to get my product newsletter. I have another list of customers. I want to make sure that even if they bought something and got a confirmation email, that they don’t get a newsletter email. This code finds the ones who do not want to get the newsletter.

SELECT * FROM customers JOIN remove ON =

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.