>>Remove both order by clauses, and put 1 after the into table command
>
>Hey, that works too! I would've never figured that out from the docs.
>Thanks,

It doesn't metter if GROUP BY is before or after INTO clause but it has to be placed after the last select because it can only by applied to the whole quiery (result of UNION).