SOQL query to retrieve Quote Line Item records from Quote Record [closed]

Question

How would I retrieve all QuoteLineItem records from a Quote record?

Answer 1

In a parent query , you can use a child sub-query, formally known as a Left Outer Join:

SELECT Id, (SELECT Id FROM QuoteLineItems) FROM Quote WHERE ...

As a separate query:

SELECT Id FROM QuoteLineItem WHERE QuoteId = :parent.Id

Answer 2

Here is the syntax from Parent to Child:-

SELECT Id [Fields...,] ,
    ( SELECT Name, [..Fields,] FROM QuoteLineItems )
    FROM Quote
    WHERE Id=:Quote_ID

Child Relationship name of Quote Line Item is: QuoteLineItems