I published an article on the Cockroach Labs Blog:
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.
So what do you think? Did I miss something? Is any part unclear? Leave your comments below.