Bases on the conversation if I understood your question correctly, you can possibly use inline views. However, before jumping to the SQL, I would suggest going through your sql statement and/or table structure since it sounds like they should be corrected.
Anyhow, consider the following
select top 5 name
from (select name
from (select top 100 percent name
from sysobjects
order by name) as a
union all
select name
from (select top 100 percent name
from syscolumns
order by id) as b) as c
order by name desc