What Is Multi-Level Relationships In Salesforce?
In SOQL, you can traverse up to a maximum of five levels when querying data from child object to parent.
SELECT Name, Position__r.Contact.Account.Owner.FirstName
FROM Job_Application__c;
SELECT Name, (SELECT Name FROM Job_Applications__r)
FROM Position__c
Five Levels:
Job Application → Position → Contact → Account → User