Salesforce Platform Developer I Certification Guide

SOQL relationships

In each database, you need to link one record to a record from another table. And, as I mentioned in the introduction to this section, SOQL has the limitation that you cannot use JOIN statements in your query. So, the next question is this: How can you select related records (or related fields) from another type of object that is linked to the initial record you want to select?

Before we go into the practice to write the relationship queries, we need to understand the relationship names of each object. Two objects always have two relationships:

• Parent-to-child relationship: One movie can have multiple cast records.
• Child-to-parent relationship: Each cast record always has only one linked movie, and that movie record has ...