Sorry, I thought you were looking for the first record in the group based on alphabetical order. I am getting the correct results with this query, but I am working with a small dataset, and am not sure that VFP is guaranteed to always get the last record:
SELECT Table1.id, Table1.vname, Table2.Name ;
FROM Table1 INNER JOIN Table2 ;
ON Table1.id = Table2.id ;
GROUP BY 1
>Oops, I found a problem again. What I really need is to find the last entry made for id = 100 and 200. My answer that I am looking for is cindi and angie since they are the last entries. The min() worked for some items when I used this on productions record which contains a hundred or so Items. Any suggestions?
Chris McCandless
Red Sky Software