>Fabio
>Great idea! Still, not quite there. As you can notice in my sample data, sometimes CTime is unique ( because it happened on Sunday for Fabio in this case ) but sometimes we can have it many times ( 2 patients the same day at the same time )
>
>Jaime
>
>>>Hi SQL gurus
>>>I have the following fields:
>>>CDate(D), CTime (C5), Patient (C30)
>>>As you may have understood, CDate holds dates, ctime times ( military ) and patient holds names.
>>>I am trying to get to the following, but since i think i may use only one UNION per select, i don't know if it's possible in one select command:
>>>

>>>CTime   Sunday    Monday   Tuesday    Wednesday
>>>-----   -------   ------   -------    ---------
>>>10:00   Sergio             Ken         Alfred
>>>10:15                                  Joseph
>>>10:15                                  Kim
>>>10:30   Fabio
>>>

>>>Well, you get the drill...
>>>
>>>TIA
>>>Jaime
>>
>>Hi
>>

>>* hypothesis : COUNT(DISTINCT CTime,DOW(CDate))<=1
>>SELECT ;
>>	CTime ;
>>,	MAX(IIF(DOW(CDate)=1,Patient,SPACE(30)))AS Sunday	; && ,CAST(NULL AS C(30)) if you want NULL
>>,	MAX(IIF(DOW(CDate)=2,Patient,SPACE(30)))AS Monday   ; && ,CAST(NULL AS C(30)) if you want NULL
>>,	MAX(IIF(DOW(CDate)=3,Patient,SPACE(30)))AS Tuesday  ; && ,CAST(NULL AS C(30)) if you want NULL
>>...
>>	FROM theTable;
>>	GROUP BY 1
>>* hypothesis : COUNT(DISTINCT CTime,DOW(CDate))>1
>>* ask me
>>

Give to me the primary key and candidate keys of the table.