Hi,<BR>I know this was covered in a previous article: 4guysfromrolla.com/webtech/110498-1.shtml and it works just fine when querying a single table but I cant make this work with an inner join. Ie: If I take the table from the example, ItemCost.ItemNumberID, ItemCost.Cost and add a table tVendor.ItemNumberID, tVendor.Address then what I would like to do is an inner join on ItemNumberID between those two tables and still retrieve only the top N values from this...<BR>Any help?