Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using GROUP BY -- which record shows in other fields.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00340232
Message ID:
00340236
Views:
23
>I am trying to get a list of the next appointment for a group of people. I can easily get a list of all future appointments for these people. To narrow it down to 1 row per person I used the GROUP BY clause. However, which record does the data come from when using GROUP BY. In other words: A person may have 10 appointments, but I have a single record for each person with a date. I don't know how it decides which of the 10 dates to display. Is it the first record, last record, random record?
>
>TIA,
>Marcus.

If the data isn't SUMmed in a GROUP BY, I believe that the information in the LAST detail row of the group is used.
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Previous
Reply
Map
View

Click here to load this message in the networking platform