>>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.
If it's not broken, fix it until it is.
My Blog