Ravi,

If two patients have the same appointment times, your original select statement doesn't get them both. So the grid only shows one name, and you don't care which one it is?

If you only want one patient name to show for each time slot, then you can use SET ENGINEBEHAVIOR. Or, you could also use MIN(patient_name) to get the first one alphabetically.

If you want every patient to show, then you can remove the group clause completely.

>>
>>Then I don't understand why you are grouping on appointment time...unless you just need to know what times were used. In that case, why is having the name of one patient relevant, if there are more than one?
>>
>All the patient names show up in the grid in teh double click event of the grid.