Update Problem

From: Satar Naghshineh <satarnag_at_worldsite.com>
Date: 1997/09/23
Message-ID: <34282139.125D@worldsite.com>#1/1

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