I published an article on the Cockroach Labs Blog:
Modesty in Simplicity: CockroachDB’s JOIN.
In this article, I explain how I designed the first (and overly simplistic) implementation of SQL joins prior to CockroachDB v1.0.
Also available via the Wayback Machine.