replacing values in a table from another table

From: Rocky <me_at_privacy.net>
Date: Sat, 13 Mar 2004 14:01:56 +0100
Message-ID: <c2v0kf$a7b$1@reader13.wxs.nl>

Hi,
I'm new to oracle and probably this is quite simple for most of you. I have 2 tables with following structure:

table1:
 pr | au | value

---

 pr1 | method |  val1
 pr1 | nometh |  nom1
 pr2 | method |  val2
 pr2 | nometh |  nom2
 pr3 | method |  val3
 pr3 | nometh |  nom3

table2:
 pr   |   au     |  value


----------------------

 pr1 | method |  new1

 pr2 | method | new2
 pr3 | method | new3

I need to replace val1, val2, val3, ... with new1, new2, new3... Who can write me the correct update statement for oracle8? Thanks! Received on Sat Mar 13 2004 - 07:01:56 CST