*snip*
>This statement got me 6 records back for my 6 cities I tested with. (no matter how many entries per day, and even if the high-temp was duplicated.)
>
>SELECT City.*, Temperature.ddate, MAX( Temperature.nhightemp);
> FROM keycust!city INNER JOIN keycust!temperature ;
> ON City.icityid = Temperature.icityid;
> GROUP BY City.ccityname;
> ORDER BY City.ccityname
Because the Date is not part of the GROUP BY clause, VFP will return the date located in the last reocrd physically in the table with the same city. With your test records, put the max temp in the first record and not in one of the later records. You should get the wroong date returned.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao