Query question

Wed, 15 Oct 2003 18:03:52 -0700

Hi!!
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
 
Thanks!!

Reply via email to