function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sudhakar reddy 13sudhakar reddy 13 

How many joins write in SOQL queries like ( Child to Parent) for multiple Objects and Thair Relation ships

How many joins write in SOQL queries like ( Child to Parent) for multiple Objects and Thair Relation ships 
     
Arun KumarArun Kumar
Hi Sudhakar.
  • In each specified relationship, no more than five levels can be specified in a child-to-parent relationship. For example,Contact.Account.Owner.FirstName (three levels).
  • In each specified relationship, only one level of parent-to-child relationship can be specified in a query. For example, if the FROM clause specifies Account, the SELECT clause can only specify the Contact or other objects at that level. It could not specify a child object of Contact.
Thanks,
Arun