Simple Join Update.

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