Re: Standard SQL?

From: Richard Freedman <rfreedm_at_voicenet.com>
Date: 1998/11/19
Message-ID: <365458F5.E4003230@voicenet.com>#1/1

If what you're trying to do is prepend '123' to the value of the column x from the dummy table, use:

select '123', x from dummy

johnnie_ng_at_hongkong.com wrote:
>
> I want to know if the following SQL is standard:
>
> select 123, (select x from dummy)
> from dummy

-- 
==============================================
Richard Freedman
Sr. Software Engineer
CHI Systems, Inc.
mailto:rfreedm_at_voicenet.com
http://www.chiinc.com
==============================================

Received on Thu Nov 19 1998 - 00:00:00 CST