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... Link to comment https://forums.phpfreaks.com/topic/21299-sql-query-format/ 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..... Link to comment https://forums.phpfreaks.com/topic/21299-sql-query-format/#findComment-94751 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? Link to comment https://forums.phpfreaks.com/topic/21299-sql-query-format/#findComment-95183 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.