In Oracle you could do this:
[sql]
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
[/sql]