Relationship queries are similar to SQL joins. However, you cannot perform arbitrary SQL joins. The relationship queries in SOQL must traverse a valid relationship path as defined in the rest of this section.
soql join in salesforce
What are Relationship (Joins) Queries in Salesforce
Relationship queries are very important when we are working as a developer or even if we are an admin.