[UPHPU] Deduping a list

[Brandon Stout]

Ash wrote:
> I have a list of email addresses and a list of those who have
> unsubscribed. (We get a new list to send to every time from our
> partner, but we have to keep track of those who have unsubscribed from
> getting our emails, and remove them from the new list every time.)
>
> So I have list 1 that has 10,000 email addresses in it and a list of
> unsubscribes that has about 200 email addresses. I want to remove all
> unsubscribes from the main list. Is there an easy way to do it?
>
> Ash
Perhaps something like:

delete * from t1
where t1.id = t2.id

Assuming that you are using a sql-capable database.

Brandon Stout
http://mscis.org