I get "Column MAXKM is not found"?


>MaxKm is a field of derived table, result of this query:
>INNER JOIN (Select kilometri.ID, Max(kilometri.stanjekm);
> From kilometri;
> GROUP BY Id WHERE datum < ldDatod) Kmtr;
>
>
>>Hmm. what is Kmtr.MaxKm??? SQL and I are confused :))
>>
>>>>Hi!
>>>>
>>>>I have table kilometri with 3 fields:
>>>>ID, datum, stanjekm.
>>>>
>>>>I want to update another table with stanjekm for max date which is less then some other date...
>>>>Here is code which work, but update for max stanjekm. This work, but when someone change km meter in his car, I get wrong result, of course....
>>>>How to get stanjekm for max datum, but less then ldDatod?
>>>>
>>>>

>>>>Update RptTjedniKm ;
>>>>	Set Startkm = (Select Max(kilometri.stanjekm) From kilometri ;
>>>>	where RptTjednikm.ID = kilometri.ID AND kilometri.datum < ldDatod )
>>>>

>>>>
>>>>Branko
>>>
>>>Try:
>>>

>>>Update RptTjedniKm ;
>>>	Set Startkm = Kmtr.MaxKm;
>>>FROM RptTjedniKm;
>>>INNER JOIN (Select kilometri.ID, Max(kilometri.stanjekm);
>>>                   From kilometri;
>>>                   GROUP BY Id WHERE datum < ldDatod) Kmtr;
>>>ON RptTjednikm.ID = Kmtr.ID
>>>

>>>
>>>Make a good backup first :-)