Comment by tuukkah

Next question: Why doesn't the query optimizer make this change automatically? The version with DISTINCT is much nicer to write and read.