I’ve apparently missed an important point about SQL joins. You know when you are trying to run a SQL query with “group by” and it nags you about needing to have each selected column in the group by…so you just stuff them all in. (Yes, you, grandma.) Anyway, that’s not the way to do it. This guy shows how to do it the right way.