asktom.oracle.com http://asktom.oracle.com/pls/ask/f?p=4950:8:2542717627406446060::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:124812348063,
or http://tinyurl.com/r3lk "pivot a result set" -----Original Message----- Teresita Castro I have the next query: SELECT COMPANY, ITEM, OEBASE.CUR_PRICE_01 FROM OEBASE WHERE OEBASE.COMPANY IN (2000,2001,2002) AND OEBASE.BASE_NAME IN ('BASE-OCJ', 'BASE-OSI','BASE-OCR') This returns for each item three lines 2000 0010041 12.34 2001 0010041 12.74 2002 0010041 11.99 I want one row per item, how can I do that? 0010041 12.34 12.74 11.99 Put the price of each company on three different fields -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
