Posts
All the articles I've posted.
Starting these notes
Why I'm writing things down in public, and what will end up here.
Why your JOIN returns more rows than either table
A JOIN that returns 40,000 rows from two tables of 200 usually means one thing. Underneath, every JOIN is a Cartesian product with a filter on top.