Table structure as follows:

'people' table:
id | name
---------------
1 | scott
2 | jim
3 | bob

'projects' table:
project_name | developer | requestor
-------------------------------------
project1 | 1 | 2
project2 | 1 | 3


So basically I want to join more than one value from the 'people' table into a query on the 'projects' table. I'd like to get something like this:

result:
project_name | developer | requestor
-------------------------------------
project1 | scott | jim
project2 | scott | bob

Is this possible in one SQL statement?