title: Salesforce and SOQL : Accessing a grandchild object from the Grandparent
body: <p>I'm attempting to access a grandchild object.</p>
  
  <p>I have 3 Objects,</p>
  
  <pre><code>     Opportunity,
            Quote,
                QuoteLineItems,
  </code></pre>
  
  <p>Opportunity is a Parent to Quote and Quote is a Parent to QuoteLineItems.</p>
  
  <p>Unfortunately, writing a query for this is proving challenging. I'm using Force.com explorer and there's no direct relationship from Opportunity to QuoteLineItems. You can can only nest Select statements one level deep.</p>
  
  <p>I'm looking to write a query that will grab all the fields from these object (I can manually enter the fields) but I'm not sure how the join logic works.</p>
  
  <p>Select ID, (Select ID From Quotes) From Opportunity.</p>
  
  <p>Somehow I need to join in the Quotelineitems in this query.</p>
  
  <p>Any thoughts?</p>