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:

enter image description here

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

enter image description here

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.

1 Answer 1


Does this work for you?

Select Product__c , Opportunity.Name, Opportunity.CloseDate, Opportunity.Theatre from OpportunityLineItem where Opportunity.Name = 'Foo'
  • Simple yet perfect solution! Thanks, not sure why I didn't think of it :)
    – Intern
    Sep 1, 2014 at 17:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .