From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx] Sent: Monday, May 23, 2005 17:46 To: 'BurtonL@xxxxxxxxxxx'; 'oracle-l@xxxxxxxxxxxxx' Subject: RE: A How-To 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Burton, Laura Sent: Monday, May 23, 2005 17:25 To: oracle-l@xxxxxxxxxxxxx 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. 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: -- //www.freelists.org/webpage/oracle-l