Database: cre_Doc_and_collections
Question: What are the different subsets of documents related to each document id , list the name of the document subset and id of the actual document ?
SQL:
select distinct t3.document_subset_name ,  t1.document_object_id from document_subset_members as t1 join document_subset_members  as t2 on t1.related_document_object_id = t2.document_object_id join document_subsets as t3 on t2.document_subset_id =  t3.document_subset_id