Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql example?
Message
From
10/08/2000 10:03:43
Gerald McKinsey
Keystone Consulting Services, Inc.
Yorktown, Indiana, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00402536
Message ID:
00403375
Views:
15
>>Larry is not saying that you will get the wrong temperature for each city; he is saying that your query will tell you the wrong DATE for that temperature. Just looking at your query, I would think the date would be incorrect, unless

You're right. I was home last night thinking about this problem, trying to figure out why it seemed like I got the right answer, but wasn't suppose to. Then it hit me, that I'm getting the right temp (after all, max(temp))
but getting the wrong record back. Two very distinct things! And that just won't do!
Nice catch, thanks for the help,

Dustin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform