I need to UNION the results of three querys. Each query returns the top 50 records os each type.

SELECT ID, MODELO, VIN, DATAHORA FROM TBMEASUREMENTS
WHERE MODELO = 'Celta 3P'
TOP 50
UNION
SELECT ID, MODELO, VIN, DATAHORA FROM TBMEASUREMENTS
WHERE MODELO = 'Celta 5P'
TOP 50
UNION
SELECT ID, MODELO, VIN, DATAHORA FROM TBMEASUREMENTS
WHERE MODELO = 'Prisma'
TOP 50

The problem: The result is only 50 records of MODELO = 'Celta 3P'
Help!!!

Eduardo


Try creating a script, squirting each of the individual queries into a memory table and then UNION those.

Remember to drop the memory tables when you've finished with them

Roy Lambert

Eduardo

Did you try increasing the TOP value for each union?

....
TOP 50
....
TOP 100
....
Top 150

Eduardo,

<< I need to UNION the results of three querys. Each query returns the top
50 records os each type. >>

You can only use TOP with the first query in a series of UNION, etc.
statements.  TOP is a "final" operation on the entire statement, so it is
only going to grab the first 50 rows of the final result set.

--
Tim Young
Elevate Software
www.elevatesoft.com