View Full Version : 'SELECT TOP n' and 'UNION' sql statement


littlelegs
05-28-2002, 02:15 PM
I am hoping someone can help me with the following statement:

SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) = "LEWANDOWSKI") And ((RIDSCORE.RIDER_F) = "Amanda") And ((RIDSCORE.LEVEL) = "B1" ) ORDER BY RIDSCORE.LEVEL UNION SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) = "LEWANDOWSKI") And ((RIDSCORE.RIDER_F) = "Amanda") And ((RIDSCORE.LEVEL) = "B2" ) ORDER BY RIDSCORE.LEVEL ;

It returns ALL records from the first select but return ONLY the 3 records requested, from the 2nd select stmt...

Any ideas?