Пересылка: select 1+3 from dual, from dummy, from ... ???

["Shulzhenko Vasyl" <vasilis@softline.kiev.ua>]

-----Исходное сообщение-----
От: Joe Lumbley <jlumbley@netcom.com>
Группы: comp.databases.informix
Дата: 28 января 1999 г. 20:54
Тема: Re: select 1+3 from dual, from dummy, from ... ???


>Carlos Daniel Orden (cdo@linux0.unsl.edu.ar) wrote:
>: Hi,
>:    I should like to know how to reference a dummy table in Informix.
>: In example: with Oracle I use the clause 'from dual', with Sybase 'from
>: dummy' but with Informix I don't know how to do it. Can you help me ?.
>: Thanks in advance.
>
>Carlos,
>You can do one of two things:
>
>     Create a dummy table called dummy. Doesn't matter what the fields are.
>         now do a "SELECT 1+3 from dummy;"
>or
>
>    SELECT 1+3 from systables where tabid = 1
>
>The where clause assures you that you'll only get one row returned.
>
>Joe
>
>--
>---------------------------------------------------------------------------
>Joe Lumbley(jlumbley@netcom.com)   author of: "INFORMIX DBA Survival Guide"
>
>The DBA Survival Guide, Second Edition will cover NT, 7.X through 7.3,
>graphical utilities, more survival hints.  Publish date:  12/16/98  FINALLY!
>---------------------------------------------------------------------------