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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.