>I am having trouble isolating records in a table that have the highest price but the nouns are the same. So if there are 50 tables, 25 chairs, 200 lamps with varying prices for each, I want a list of 3 items, a table, a chair, and a lamp, with each of the 3 having the highest price in its category.
>Is there a way to prg this in foxpro or is sql needed?
SQL is the easiest way Tim IMHO.
Select itemname, max(price) as Highest from mytable group by 1
Cetin