Oracle select/update with join

See more:

SQL

Oracle

I have tableA and tableB which can join by ids. I am trying to figure out how to write it such that I can select the tableA.color and tableB.value and do an update for the column in tableA called color that will get changed from "blue" to "red" for a row but only if the column in tableB called value is greater than 10.

so the result set


color value
blue 7
blue 3
red 12
blue 1
red 14


What I have tried:

I was thinking something along the lines of

<pre>select tableA.color, tableB.value
from tableA
inner join tableB on tableA.id = tableB.id
update tableA
set tableA.color = "red"
where tableB.value > 10

Wasn't sure on syntax and including the join.