Re: Standard SQL?

From: <weedwiper_at_my-dejanews.com>
Date: 1998/11/19
Message-ID: <73247h$4f1$1@nnrp1.dejanews.com>#1/1

In article <Pine.BSF.3.96.981119181810.12224C-100000_at_prima.netfront.net>, "johnnie_ng_at_hongkong.com" <johnnie_at_hongkong.com.hk> wrote:
>
> I want to know if the following SQL is standard:
>
> select 123, (select x from dummy)
> from dummy

There is nothing wrong with the SQL per se, but it would be better written as

select 123, x
from dummy

which achieves the same result as your query in less databases accesses.

--
David Owen  7, Stradbrooke Rise SW, Calgary, AB, Canada
dowennospam_at_spam-off-cadvision.com

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

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