grudz
10-12-2004, 09:28 PM
Hi,
I have a web page where users enter their email address to be added into a table (for a future newsletter) however, if they become a member (which is another table) i don't need the email anymore. Now to make it more simple, I don't need to do an UPDATE query. What i'm going to do is create another page that'll show the list of emails from the newsletter table, except the duplicates from the members table.
i guess something like this
SELECT newsletter,member WHERE newsletter.email != member.email
Does it make sense?
Thank you
i'm sorry, this is a MYSQL question...i'm gonna post it there...sorry
I have a web page where users enter their email address to be added into a table (for a future newsletter) however, if they become a member (which is another table) i don't need the email anymore. Now to make it more simple, I don't need to do an UPDATE query. What i'm going to do is create another page that'll show the list of emails from the newsletter table, except the duplicates from the members table.
i guess something like this
SELECT newsletter,member WHERE newsletter.email != member.email
Does it make sense?
Thank you
i'm sorry, this is a MYSQL question...i'm gonna post it there...sorry