building sets in SQL92

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

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:27:46 CEST