Flatten data help please?

Still learning! Appreciate the use of bandwidth ahead of time! Oracle 8.1.4 Data exists in 3 tables
tblIdWeeks
WeekID,WeekStart, WeekEnd
tblIDDates
AirID, WeekID,DayNum (0 thru 6),DayDate
Leave_Detl_tbl
Effective_Dt, Leave_type, Input_AM

existing sql is:SELECT tblIDAirWeeks.WeekStart, tblIDAirWeeks.WeekEnd, tblIdAirDates.AirDayDate, [ORIG_LEAVE_TYPE_CD] & " " & [ORIGINAL_INPUT_AM] AS Expr1 FROM tblIDAirWeeks
INNER JOIN (tblIdAirDates INNER JOIN AMS_AHRSADM_LEAVE_DETL_TBL ON tblIdAirDates.AirDayDate = AMS_AHRSADM_LEAVE_DETL_TBL.EFFECTIVE_DT) ON tblIDAirWeeks.AirWkID = tblIdAirDates.AirWkID WHERE (((tblIDAirWeeks.WeekStart)>#12/27/2000#) AND
((tblIDAirWeeks.WeekEnd)<#1/5/2002#) AND
((AMS_AHRSADM_LEAVE_DETL_TBL.INTERNAL_EMPL_ID)="0000000357"));
I get data returned like so:

WeekStart WeekEnd AirDayDate Expr1

1/21/01    1/27/01  1/23/01    SICKF 450
1/21/01    1/27/01  1/24/01    FLH   450
1/21/01    1/27/01  1/25/01    FLH   450
1/21/01    1/27/01  1/26/01    VAC   450

And would like a result that looks like this:
WeekStart MON    TUES       WED     THURS     FRI    WeekEnd
1/21/01        SICKF 450  FLH 450  FLH 450  VAC 450  1/27/01  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Steve
  INET: stvjston_at_sapphire.jcn1.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).