Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Records matching MAX(Date)
Message
 
 
To
21/08/2002 12:36:50
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00690278
Message ID:
00692057
Views:
30
>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

I guess, I just understood your original code. You're right, it's an indirect grouping and I just didn't understand it, because I never tried :)

Thanks again and sorry for confusion...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform