View Full Version : Showing data from a column depending on another

10-12-2004, 10:28 PM

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