SQL problem when using MAX(Date) and GROUP BY

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL problem when using MAX(Date) and GROUP BY

Message

From

26/10/2002 07:04:26

Stewart Coombs
Feba Radio
Worthing, United Kingdom

11/10/2002 11:19:37

Sylvain Larin
Montréal, Quebec, Canada

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: SQL problem when using MAX(Date) and GROUP BY

Miscellaneous

Thread ID:

00710331

Message ID:

00715745

Views:

Thanks Sylvain, that was almost exactly what I wanted. I added the same INLIST() statement to the sub-query and it now returns the correct answer.

Stewart

Map

View

Click here to load this message in the networking platform