>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?

>Oh Darn - I just also noticed that you do *not* select any fields! This is a *must do too, in *both* selects (even if you want "*" for all fields).

WHY??

Vlad