I do not keep email addresses in this table because some users have more than 1 email address….I keep them in a table named ‘email’. In the email table I have 2 fields, 1 for username and 1 for email.
So what is common to these tables in the username fields.
What I want to do is to select all the email addresses of staff who are permitted to upload files. So, in layman terms the query would look like (I think):
SELECT username, email_address FROM email AND username, uploads FROM users WHERE uploads = ‘Yes’
So that at the end of the query I should have the email addresses of the users who are allowed to upload to the Intranet server.
I must have been staring at this for too long as I can’t get it working. Help please?!?!