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?
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?