I found this article interesting. The author has detailed the mechanics of joins in a very elaborate way. Very easy to understand and was a good refreshing moment reading the same.
Thanks,
Santosh Gaikwad