markbett Posted September 19, 2006 Share Posted September 19, 2006 I am strugling with how to properly write this sql query. I have 2 tablesusers and anti_spamI 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... Quote Link to comment Share on other sites More sharing options...
markbett Posted September 19, 2006 Author Share Posted September 19, 2006 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..... Quote Link to comment Share on other sites More sharing options...
fenway Posted September 20, 2006 Share Posted September 20, 2006 Does the anti-spam table not contain a user_id? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.