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 demo
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.