Re: Sql query

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 13 May 2003 12:39:56 +0200
Message-ID: <1052821936.892673@news.thyssen.com>

"Joshua Lool" <josh1977_at_libero.it> schrieb im Newsbeitrag news:606d36fba9669f6964215b4cd0d62438.84112_at_mygate.mailgate.org...
> Update PIPPO set FIELD =
> DECODE(FIELD1,'AA', DECODE(
> SELECT COUNT (DISTINCT FIELD1) FROM
> TAB
> WHERE ANNO = '2003' , '1' ,'100', '90'), '100')
> WHERE ANNO = '2003'
>
> Where is the error ?
>
> Thanx

Hi Joshua,

the (obvious) error is: using SELECT in the DECODE. It's simply not allowed.

hth,
Guido Received on Tue May 13 2003 - 05:39:56 CDT