Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Hari N 20Hari N 20 

Single SOQL Query

Hi All,
I have one custom object under account related list.

How to retrieve that custom object fields using single SOQL query? 
Naveen DhanarajNaveen Dhanaraj
Try this 
[Select Id, Name, (Select Id, Name From Custom _Object__r) From Account__c];

 
Naveen DhanarajNaveen Dhanaraj
Go Through this Links,

http://www.sfdc99.com/2013/06/24/example-how-to-write-a-cross-object-soql-query-part-2/
Hari N 20Hari N 20
I dont want to use multiple objects in SOQL query.
Can we do like that?
Naveen DhanarajNaveen Dhanaraj
  1. If you have relationship between objects then only we can have related list in other object.
  2. As well as  field dispalyed in related list also based on relationships.
  3. without relationships I dont think so this possible.