I don't know why SQL has always been so confusing to me. When he puts it this way, joins make perfect sense. But before reading this guide and this SO answer[1], they just felt like black magic. I don't understand why.

[1] https://stackoverflow.com/a/4401540/30477628