Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using GROUP BY -- which record shows in other fields.
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using GROUP BY -- which record shows in other fields.
Miscellaneous
Thread ID:
00340232
Message ID:
00340232
Views:
71
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.
Next
Reply
Map
View

Click here to load this message in the networking platform