Apex Code Development You need to sign in to do that
Don't have an account?
Chris987654321 SQQL Help
I'm looking for the SQQL statement that would allow me to get the Name field from the Indvidual table where the Name.Id record equals the At_Risk__c.Student
Individual At_Risk__c
Id | Name Student
1234 | Joe Smith 1234
So in the above tables, I would try to get Joe Smith from the Individual Table.
I tried something like:
But I know I'm doing something wrong.
Does anyone have some places I could start for ideas to fix this?
Message Edited by Chris987654321 on 02-11-2008 10:43 AM
Message Edited by Chris987654321 on 02-11-2008 10:58 AM
Individual At_Risk__c
Id | Name Student
1234 | Joe Smith 1234
So in the above tables, I would try to get Joe Smith from the Individual Table.
I tried something like:
Code:
Select Individual.Name FROM Indiviudal, At_Risk__c WHERE Indivudual.Id=At_Risk__c.Student
But I know I'm doing something wrong.
Does anyone have some places I could start for ideas to fix this?
Message Edited by Chris987654321 on 02-11-2008 10:43 AM
Message Edited by Chris987654321 on 02-11-2008 10:58 AM
Check the API docs, there's numerous examples of queries like this.
bjohnsonCheck out http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=sforce_api_calls_soql.htm under "Relationship Queries".
Chris987654321Thank you I could not find the documentation I needed.