helo,
my report have this format:
dept. admissions discharges
M/S F/S M/N F/N M/S F/S M/N F/N
DERMATLGY 23 0 2 1 12 5 2 0
OPTHALMGY 3 0 12 1 1 15 2 0
ETC...
LEGEND :
MS - Male Sudanese
FS - Female Sudanese
MN - Male non-Sudanse
MF - Female non-Sudanse
now this report comes frm various tables and i was able to obtain this by using separate SELECTs statements for every Admissions, Discharges, Discharged-Alive, Disch-Dead and is not a pretty site.
any tips on how to, in an elegant way.. thanks