>>>Ok, here is a problem:
>>>

>>>town  fullname  dateBeg DateEnd
>>>
>>>town1 fullname1 date1 date2
>>>town1  fullname1 date3 date4
>>>
>>>townN fullname1 date1N date2N
>>>townN  fullname1 date3N date4N
>>>

>>>
>>>We need info from this table for each town code, which corresponds to max dateEnd
>>
>>Nadya,
>>Still can't see what's different.
>>Cetin
>
>You don't have Group BY in your original example.

Why should I have it ?
Cetin