Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

A join is necessary whenever you have some code that needs to access records on both sides of that association (both the record that holds the reference and the record being referenced).