Re: Update Problem

From: Dmitriy B. Agafonov <dagafono_at_rgti.com>
Date: 1997/09/23
Message-ID: <34285052.55712986@rgti.com>#1/1

Wrong syntax of UPDATE.
Try this:
update oldtransactions

set custid = (select custid from transactions where cc = oldtransactions.cc);

Regards,

Dmitriy Agafonov

Satar Naghshineh wrote:

> hi
> What are we doing wrong?
>
> update oldtransactions
> set custid = transactions.custid
> where oldtransactions.cc = transactions.cc
> *
> ORA-00904: Invalid Column Name
>
> cc is a column in a table called transactions, so why is Oracle giving
>
> us this message?
>
> Thanks in Advance,
> Satar Naghshineh
Received on Tue Sep 23 1997 - 00:00:00 CDT