From: Thomas Jegen Newsgroups: comp.databases.oracle.misc Subject: Re: Multiple recordsets in 1 select Date: Wed, 06 Jun 2001 12:48:24 +0200 Organization: Siemens Schweiz AG Lines: 27 Message-ID: <3B1E0A78.998438BE@siemens.ch> References: Reply-To: thomas.jegen@siemens.ch NNTP-Posting-Host: chad114c.zrh.siemens.ch Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: de-CH,fr-CH Hi Just add 'from dual' to your example: SELECT (SELECT account FROM docs WHERE id=596 and type='sales') "accSales" , (SELECT account FROM docs WHERE id=596 and type='it') "accIT" , (SELECT account FROM docs WHERE id=596 and type='mech') "accMechanics" from dual Thomas -- _______________________________________________________________________ Siemens Switzerland Ltd, Softwarehaus, ES41 Thomas Jegen, Software Engineer Albisriederstrasse 245, CH-8047 Zürich Phone +41 (0)1 495 3438, Fax +41 (0)1 406 5340 mailto:thomas.jegen@siemens.ch, Internet: http://www.siemens.ch/