Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 28, 2012 08:46 AM by mullsey
Mar 28, 2012 07:36 AM|LINK
I hope someone can help with this.
What I am trying to do should be fairly simple I think.
I have a list of email addresses that have unsubscribed from my mailing list. I have put these into a table. I have another table which I add new contacts to. What I want to be able to do is create a query that joins the email address from my master list
to the email address in my unsubcribe table. I want to return all rows from the master list except those that exist in the unsubscribe list.
Can anyone please give me some ideas on hot to do this.
Mar 28, 2012 07:49 AM|LINK
Hope this helps...
Mar 28, 2012 07:51 AM|LINK
select mail from masterTable where mail not in (select mail from unsubcribeTable)
This is it :)
Mar 28, 2012 08:46 AM|LINK