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
sql for everyone
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