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?

In Oracle you could do this:
SELECT
 projects.name,
 (SELECT name FROM people WHERE id=projects.developer) AS "developer",
 (SELECT name FROM people WHERE id=projects.requestor) AS "requestor"
FROM
 projects

For some reason you might prefer this:
SELECT
 projects.name,
 developer.name AS "developer",
 requestor.name AS "requestor"
FROM
 projects
JOIN people developer ON (developer.id = projects.developer)
JOIN people requestor ON (requestor.id = projects.requestor)
Consider however the type of join you need (perhaps "left" one?).