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.
