Multi Value Results from Nested Query

Question

I have a parent-child nested query like to this:

SELECT Name,CloseDate,Theatre,(Select Product__c from Opportunity.OpportunityLineItems) from Opportunity  where Name = 'Foo'

The result of which, looks like this:

But I don't want the result nested within the table, I'd like it like this:

I know this may be down to the normalization of the table, but i don't have control over that in Salesforce, so is there a way to do this from the query or how I am retrieving the result?

I think that's all the relevant information, any help would be appreciated.

Answer 1

Does this work for you?

Select Product__c , Opportunity.Name, Opportunity.CloseDate, Opportunity.Theatre from OpportunityLineItem where Opportunity.Name = 'Foo'