Posted by Hugo Kornelis on 08/10/05 18:18

On 10 Aug 2005 08:12:17 -0700, --CELKO-- wrote:

(snip)
>This statement will error out when Bloob has more than one qualifying
>store. The UPDATE FROM syntax will give you a random result.

Hi Joe,

You forgot to tell the OP that the statement you posted will also set
the column to NULL in all rows that have no qualifying store. Something
the OP didn't want, judging by the EXISTS clause in the query he posted.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]