>The record with the IID = 5 does not have NVALUE=0 - so this is not appropriate to the record where it was found.
I see. Something spoiled compare to what we had in FoxPro 2.5, because I alwayse used such types of query in my old applications... :( Will try to play with it more, maybe there're some clues for this.
>2) CCATEGORY, IID combination is always unique - but, then what's the problem with including IID in the GROUP BY list?
The problem is that we need MIN value inside 1 cateory. When you include ID into grouping, you will get all records (ID usually is unique field)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.