RE: A How-To

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 24 May 2005 03:41:04 -0500 (EST)
Message-Id: <20050523154231.EF9FE42BA@node42.naturaljoin.lan>

Laura,
please provide some more info -- like a describe of the two tables involved? also, showing headings above your query results below, and the queries themselves,
would help enormously :-)

kind regards,

Lex.

Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura
Sent: Monday, May 23, 2005 17:25
To: oracle-l_at_freelists.org
Subject: A How-To

I have a table which has multiple records for one individual. Each record represents a different field, i.e. id 31 represents start time, id 19 represents shift, id 10 represents rate, etc.

012222                                  0 PR

31 700

012222                                  0 PR
19            1ST                   

 

012222                                   0 PR

10 10.00

What I want is to have each record to be listed as a column in a select statement so that I have a line that shows the following:

012222              700                   1ST                    10.00


012444              900                   1st                     20.00

etc.

Could someone please advise? I have tried but the closest I've come is not good enough.

SELECT EMPL_ID, (SELECT UDEF_TXT FROM DELTEK.GENL_UDEF WHERE GENL_ID = EMPL_ID AND UDEF_LBL_KEY = 31 ) "START TIME" FROM DELTEK.EMPL, DELTEK.GENL_UDEF WHERE EMPL_ID = '012222' AND EMPL_ID = GENL_ID EMPL_ID START TIME

------------------------------

012222 700

Thank you!! Laura

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 24 2005 - 04:44:02 CDT