Question on Update

From: <jeff.w.mcclure_at_ameritech.com>
Date: Thu, 23 Apr 1998 11:36:29 -0600
Message-ID: <6hnqmd$egl$1@nnrp1.dejanews.com>

Hi folks,

I have a table (alertinfo) containing columns:

alert number,
...
(other columns)

...
ticket number,
tstatus varchar2(15)

I have a second table (ticketinfo) containing columns:

alert	number,
ticket	number,

status varchar2(15)

I need to update the alertinfo table setting the ticket and status equal to the fields in ticketinfo where the alert columns match. I have tried many variations of update without success. The problem appears to be in the outer where clause.

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. This seems as though it should be simple but I am having a very difficult time making it work.

Can someone provide some assistance?

TIA, Jeff McClure
Specialist DB Analyst
jeff.w.mcclure_at_ameritech.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 23 1998 - 12:36:29 CDT