'SELECT TOP n' and 'UNION' sql statement

littlelegs

Registered User.
Local time
Today, 09:11
Joined
May 8, 2002
Messages
10
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?
 

Users who are viewing this thread

Back
Top Bottom