I am unable to understand relationships with DML/SOQL.
Example, I have custom objects
Course_line_item__c has a lookup field on it that points to
Course__c. So this means multiple
Course_line_item__c's can have the same parent
So I have this SOQL Query :
list<Course__c> LC=[SELECT Id, (SELECT Id FROM Course_line_item__c) FROM Course__c];
and I'm getting this lovely error :
Compile Error: Didn't understand relationship 'Course_line_item__c' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names. at line 13 column 12
What am I doing wrong???
EDIT : me custom relationship field is called