Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECTing MAX()
Message
From
13/12/2000 11:32:19
 
 
To
13/12/2000 11:15:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00452686
Message ID:
00452898
Views:
25
>How about this - assuming that id and score are numeric fields

Since you used Transform() an ID of 2 and a Score of 18 they key will be 218 wich will also match with an ID of 21 and a score of 8. Right?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform