Re: Question on Update

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Fri, 24 Apr 1998 16:26:36 GMT
Message-ID: <6hqefp$bis@bgtnsc03.worldnet.att.net>

On Thu, 23 Apr 1998 11:36:29 -0600,
jeff.w.mcclure_at_ameritech.com wrote:

>update alertinfo
>set (ticket, tstatus) =
>(select ticket, status
> from ticketinfo)
>where ticketinfo.alert = alertinfo.alert;
>
>I receive an ORA-00904: invalid column name
>referring to ticketinfo.alert.

You need to write it like this:

update alertinfo

	set ticket = (select...),
            tstatus = (select...);

At least, that's the only way I've ever known to do it. Received on Fri Apr 24 1998 - 11:26:36 CDT