>Here is the code in question.
>
>
SELECT Appointments.app_time, Appointments.app_date,;
> Appointments.pat_last;
> FROM appointments;
> where appointments.app_date >= mquerydate .AND.;
> appointments.app_date <= mquerydate + 8;
> GROUP BY Appointments.app_time, Appointments.app_date;
> ORDER BY Appointments.app_time, Appointments.app_date;
> INTO CURSOR existingappoints nofilter
>
>And sice this code does not contain aggregate functions the GROUP BY clause should include Appointments.pat_last?
Yes. Aggregated fields are the only ones that do not need to be in the GROUP BY. All else do.
>What if there were 10 fields in teh select statement, has a Group By clause, and no aggregate functions. Should all the 10 fields be identified in the Group By clause, and in the order of how they should be grouped?
Yes. Same as above.
>Thank you for your time Mark. It is appreciated.
You are welcome.
Mark McCasland
Midlothian, TX USA