...

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



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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum