Thanks, I was hoping there was some way to avoid it.
> You have to write the subselect twice if you want to match up different
> rows.
> In some cases it might be worth making a copy in a temp table. For simple
> subselects where there is an index on id, leaving it as is should work
> fine.
>