June 15th, 2012, 09:22 AM
|
|
Contributing User
|
|
Join Date: Oct 2006
Posts: 142
Time spent in forums: 11 h 32 m 7 sec
Reputation Power: 7
|
|
|
UNION for ordered tables
Hi,
I'm trying to run this code and it doesn't work. I'm sure it's quite self-explanatory of what it's trying to do
Code:
select * from equity.dbo.accounts
order by currency
union all
select * from equity.dbo.accounts
order by entity
Is there a way to do this?
__________________
Cheers,
Fred Liu
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
