View Single Post
  #1 (permalink)  
Old March 30th, 2005, 04:28 PM
ibi ibi is offline
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default SELECT TOP n NOT SELECTING TOP n!

Hey guys,

I've got a problem that's been giving me a headache and I can't get my head around it, hope you guys can inspire me!

I'm trying to execute a normal SELECT TOP 10 * FROM Table WHERE blah blah.. but it's selecting ALL fields and not the TOP 10!

This is my query:

SELECT TOP 10 * FROM Product WHERE ((Product.ManufacturerFeaturedOrder) Is Not Null) AND ((Product.ManufacturerID)=0) AND ((Product.Active)=True) ORDER BY Product.ManufacturerFeaturedOrder;

Please advise!

ibi
Reply With Quote