[thelist] SQL Union and order by problem

[XtiaN]

Hi,
can anyone help me ?

I've made some sql query like this (SQL Server 2000):

select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())>=3 
order by b desc) asd 
union all
select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())<3 
order by b asc) def


explanation:
i want to make query from union of 2 subqueries.
subquery 1 : simple query with order by b desc
subquery 2 : simple query with order by b asc
btw, a =  primary key (index)

But the result is not like i'd expected.. 
well, the result make all datetime data in column b order by asc... (not by desc first for subquery1, and followed by asc from subquery2)


ps: i added 'top 100 percent' because if i don't this message error will come ->
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

thanks in advance

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com