Child to Parent SOQL Query

Question

I need a query between Opportunity and OpportunityLineItem.

OpportunityLineItem has a lookup for Opportunity. Child relationship name is OpportunityLineItems. Opportunity Lookup field is called OpportunityId.

I'm trying the below query but it doesn't work.

select Id,Name,OpportunityId__r.Description from OpportunityLineItem

Also tried:

select Id,Name,OpportunityLineItems__r.Description from OpportunityLineItem

score 1 · Accepted Answer · answered Oct 03 '22 at 17:08

Top-down

SELECT Id, Name, Description,
    (SELECT Id, Name FROM OpportunityLineItems)
FROM Opportunity

Bottom-up

SELECT Id, Name, Opportunity.Name, Opportunity.Description
FROM OpportunityLineItem

Check out the links in https://stackoverflow.com/a/73913839/313628 and https://stackoverflow.com/a/73877986/313628 too

Child to Parent SOQL Query

1 Answers1