>
>Because I changed the definition of original problem to make it a little bit more complicated. We need to find information about each town record, which has a maximum date. So, we have to group on towns...
>
>Anyway, it looks like you're refusing to provide an answer :) I guess, I can solve this problem myself or already solved it. Just thought, that the solution could be of interest to others...
Nadya,
Refusing ? Oh my if I ever understood what you want I'd provide the answer (assuming I might have an answer). Simply cannot see how your problem differs from the original one. IOW I can't see the need for grouping. SQL checks if record is a match for a particular group (Ino there Town in your case with maxdate of that group). If it's includes in result list. That's not 'group by' but an indirect grouping. Glad you solved.
Cetin