self-join

in order to get the name of a document and the project that contains it – I needed a self-join

select d1.name as docname, d2.name as Project
from stuff d1, stuff d2
where d1.ownerid = d2.id
order by Project