Re: building sets in SQL92

values('boston') union values('ny')
will work
Thanks
Aakash

"Sten Loecher" <sten-loecher_at_gmx.de> wrote in message news:9f5n16$7cv$1_at_kastor.inf.tu-dresden.de...
> Hi folks,
>
> I need to write a query in SQL92 that builds a set "on the fly" for use as
> kind of temporary table. For example, in Oracle SQL I could write:
>
> select 'Boston' as CITY from DUAL
> union
> select 'Atlanta' as CITY from DUAL
> union
> select 'Columbia' as CITY from DUAL
>
> with DUAL as a table that has one column and one row, because I must
> specify some table.
> The result of this query would be:
>
> CITY
> ------
> Boston
> Atlanta
> Columbia
>
> In SQL92 one can write this query too, which told me the according
 grammar.
> The specification of a table is also mandatory.
> What I'm thinking about is, wheter the semantic is supposed to return the
> same result like in Oracle or wheter such a such a query is allowed at
 all.
> Maybe there is still another way to build such a set in SQL92, isn't it ?
>
> Would appreciate any help.
>
> Sten
>
>
>
>
>
Received on Sun Jul 22 2001 - 01:28:19 CEST