Recently I have been working a lot in content management system. I have 2 standard objects- contentDocument and contentfolderitem. I assumed the contentfolderItem as master and contentDocument as detail object. The Id of the contentfolderItem is actually the Id in contentdocument when the contentfolderitem is actually a file.
I need to get the contentsize in contentdocument object and ParentContentFolderId in contentfolderitem in single soql query. Is it possible to do this?