>>The ODER BY *must* be in the final SELECT only. Since the Help does *not* say any restrictions about TOP, I would suppoose that it *also* should be in the last select.
>
>Why in the last one?
Because 'dems 'da rules ;) And you need to identify them by their column number, *not* their name.