5.19SOQL relationship queries

This is the most important difference from traditional SQL for this module.

Salesforce supports relationship traversal rather than forcing you into conventional table JOIN syntax. Relationship queries work through lookup/master-detail relationships and can traverse both child→parent and parent→children directions.

Let's make this easy.