Re: ADO Query Help

Grant wrote:

Thanks ALot This worked , But I wornder ..........I did not see a
statment about Team........How did it know to get the curent team
with the max points at the same time.

I am not sure I understand your question. The asterisk in SELECT * ...
means to return all fields in the record. Note that the query I
provided could return more than one record if there were multiple
records with the max value of Points.

--
Bill Todd (TeamB)
.