Easy Union Question 2

[GRHE]

I have a group of four selects all union'd. Is there a way of getting the top 1000 of "all of the results". I have tried top 1000 in each of the selects but that returns 4,000??

It's Friday and I want to go hom

 

[JamesLean]

SELECT TOP 1000 FROM
  (
  SELECT * FROM t1
  UNION
  SELECT * FROM t2
  UNION
  SELECT * FROM t3
  UNION
  SELECT * FROM t4
  )
ORDER BY col1

--James

 

[GRHE]

Cheers I can go to the pub now