Re: Multiple recordsets in 1 select

From: Gerry Jacobs <gee_jay__at_yahoo.com>
Date: 11 Jun 2001 08:26:31 -0700
Message-ID: <ce2b54c8.0106110726.67428cd@posting.google.com>

Thanks

Gerry Jacobs

Thomas Jegen <thomas.jegen_at_siemens.ch> wrote in message news:<3B1E0A78.998438BE_at_siemens.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/
Received on Mon Jun 11 2001 - 10:26:31 CDT