function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Trying to query reference items but they are null or invalidate query?

So, here is my structure in Apex Explorer 8.0 to help get an idea of what im trying to query



   - Site__c reference

       -  Attribute

       -  label

       -  Site_r


           - bunch of stuff i need 

       - type - reference



     Select Site__c.Site__r from case


   or Select Site__r from case


  select Site__c.Site__r.Name from case


 None are valid and even look close to correct. How do i tell it to grab the Site__c -> Site__r which has all the info i need?


Message Edited by tyweed on 03-09-2009 09:04 PM
select site_r.someField, site__r.someOtherField from case. see the SOQL-R section in the api docs.