title: SOQL - How to obtain Parent Name of CombinedAttachments
body: <p>I am unable to obtain the Name of a Parent object, where the child is CombinedAttachments.
  The SOQL I use is listed below and works as expected.</p>
  
  <blockquote>
    <p>SELECT  ( SELECT Id, Title, RecordType, LastModifiedDate,
    CreatedBy.Name, ParentId  from CombinedAttachments    WHERE  ParentId
    = '001b0000009ovxS'       ORDER BY LastModifiedDate DESC limit 100  )  FROM Account WHERE Id = '001b0000009ovxS'</p>
  </blockquote>
  
  <p>What is impossible is to add a filed like Parent.Name or Parent.Account.Name.
  However, in other cases of Parent-Child queries like that, it is straightforward to refer to Parent fields by using dot notation like Parent.CaseNumber or Who.Name
  It seems that due to the fact that there may be multiple references possible in ParentID (Account,Asset,Campaign,Case,Contact,Contract,EmailTemplate,Event,Lead,Opportunity,Product2,Solution,Task)</p>