>The following select works without the 'order by' clause. When I put it in, it also adds 'top 100 percent' by default, and generates an error. I have tried saving the select without the 'order by' and calling it from another select (view), but that still generates the error. Is there an easy way to do this??
>
>Thanks in advance!

Uh, what select?