Simple Join Update.
From: <andrewdmetcalfe_at_hotmail.com>
Date: 10 Apr 2003 08:54:02 -0700
Message-ID: <1c73e01f.0304100754.3224563c_at_posting.google.com>
Date: 10 Apr 2003 08:54:02 -0700
Message-ID: <1c73e01f.0304100754.3224563c_at_posting.google.com>
I'm perplexed that I'm unable to do a rather simple join update.
update a
set a.col2 = b.col2
where a.col1 =b.col1
I get an error message saying ORA00904: invalid column name on "b.col1".
I've done this in Access... I'm surprised I can't do this in Oracle.
Why not?
I'm also perplexed as to coming up with an alternate way of doing this.... yet I'm sure there's an easy solution.
Thoughts?
_Am Received on Thu Apr 10 2003 - 17:54:02 CEST