Re: building sets in SQL92

From: Per Schröder <per_at_nospam.mimer.se>
Date: 3 Jun 2001 19:02:15 GMT
Message-ID: <Xns90B5D56BF52F6pescatmimer@192.71.97.199>

"James Chapman" <Jim.Chapman_at_nospam.elsegundoca.ncr.com> wrote in <3b17fbcd$1_at_rpc1284.daytonoh.ncr.com>:

>That will work in DB2, but it is not part of SQL-92.
>
>"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message
>news:9f8nt8$10ts$1_at_stlnews.stl.ibm.com...
>> values('boston') union values('ny')
>> will work
>> Thanks
>> Aakash

That construct is indeed valid in full SQL-92.

--
/Per Schröder
http://developer.mimer.com

Received on Sun Jun 03 2001 - 14:02:15 CDT