Re: Multiple recordsets in 1 select

From: Thomas Jegen <thomas.jegen_at_siemens.ch>
Date: Wed, 06 Jun 2001 12:48:24 +0200
Message-ID: <3B1E0A78.998438BE@siemens.ch>

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/

Received on Wed Jun 06 2001 - 05:48:24 CDT