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

Case

- Site__c reference

- Attribute

- label

- Site_r

- bunch of stuff i need

- type - reference

Query

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

Superfell
select site_r.someField, site__r.someOtherField from case. see the SOQL-R section in the api docs.

Need an account? Sign Up

Have an account? Sign In