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