Jump to content

Archived

This topic is now archived and is closed to further replies.

markbett

sql query format

Recommended Posts

I am strugling with how to properly write this sql query.  I have 2 tables

users and anti_spam

I need to select the email address of all users who have not unsubscribed... antispam has columns id email_address, events, newsletter, invitations, news.... so if a column is marked then the email address in question has unsubscribed so basically its is a query where i say join on email addresses where newsletter = '0'

is that right? Im not too good with complex sql queries...

Share this post


Link to post
Share on other sites
oh and for clarification there are email addresses that will appear in the anti_spam database table that will not be in the users table.....

Share this post


Link to post
Share on other sites
Does the anti-spam table not contain a user_id?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.