Getting myself bloggin again with a new Write Freely instance. I wrote a summary of the various SQL join types, partly to test myself, and surprised myself by actually remembering them all  

https://blog.tsvallender.co.uk/joins-in-sql

Joins in SQL

When learning SQL, one of the first trickier things to get your head around are the various ways to join one table to another. Here, I’m ...

~tsvallender
I think I’ll follow this up with the related topic of the various methods in Rails to avoid N+1 issues, because the difference between them all _still_ throws me sometimes.