Unanswered: Retrieving names from multiple user IDs in one record
I have what I hope is a simple question (I'm relatively new to SQL and databases in general, so forgive me if this is a stupid question).
I'm working with an ActivityLog table that contains three user ID fields (AnalystID, ReviewerID, and ManagerID). I want to retrieve the full name of each of these users from a Users table. What I'm trying to figure out is how to setup a query to retrieve more than just one of the names. The query to retrieve the AnalystID by itself looks like this:
FROM ActivityLog INNER JOIN Users ON ActivityLog.AnalystID = Users.ID
However, I want the query to contain three different Users.Fullname fields, with each corresponding with one of the three user ID fields. Is it possible to do this?