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.
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'
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)