Populating a column in one table with a column in another table
Ok, so here is my latest challenge. I store outgoing emails in a table called notifications. In that table is a column called recipient, which is an email address. I recently added a new column to the notifications table called userID. Since I have the receiver's email address, I need to somehow get the userID from the user's table, and add it to the userID of the notifications table. Can someone suggest a way this can be accomplished?