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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to