+ 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