Message
From
30/11/2002 18:34:07
Janis Booth
Webmd
Prospect
,
Connecticut
,
United States
To
30/11/2002 16:28:12
Gerard O'Carroll
Kernel Software Ltd.
Dublin
,
Ireland
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re:
Can this be done with SQL statement
Miscellaneous
Thread ID:
00728373
Message ID:
00728417
Views:
17
Gerard,
Your problem is that the * is getting both fields, simply change the select to ...
SELECT
FldA,
MAX
(FldB)
FROM
TableName
GROUP
BY
FldA
INTO
CURSOR
Result
Janis
www.JamesBooth.com
Previous
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only