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

Leave a Reply

Your email address will not be published.

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