<div>
you might want to add one more clause to joebednarz's solution<br />
&nbsp; <br />
... where b.fld2 in (select a.fld2 from tableA)<br />
<br />
cheers!<br />
Don
</div>


you might want to add one more clause to joebednarz's solution
 
... where b.fld2 in (select a.fld2 from tableA)

cheers!
Don

<div>
<div class="content wysiwyg-content">
I need to update a table based on the output of a select. <br />
Example:<br />
Select a.fld1, a.fld2 from db.tableA a where a.fld3 = 'blahblah' <br />
The output might be something like<br />
fld1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fld2<br />
'TEXT1' &nbsp; &nbsp; &nbsp;123<br />
'TEXT2' &nbsp; &nbsp; &nbsp;432<br />
'TEXT3' &nbsp; &nbsp; &nbsp; 534<br />
etc..<br />
<br />
I'd like to be able to update tableB based on the results of this select.<br />
<br />
update db.tableB b set b.fld1 = a.fld1 where b.fld2 = a.fld2<br />
<br />
how would write such an update command?<br />
<br />
i hope i'm &nbsp;explaining myself clearly - ?
</div>
</div>


I need to update a table based on the output of a select. 
Example:
Select a.fld1, a.fld2 from db.tableA a where a.fld3 = 'blahblah' 
The output might be something like
fld1           fld2
'TEXT1'      123
'TEXT2'      432
'TEXT3'       534
etc..

I'd like to be able to update tableB based on the results of this select.

update db.tableB b set b.fld1 = a.fld1 where b.fld2 = a.fld2

how would write such an update command?

i hope i'm  explaining myself clearly - ?

How to update a table based on the output of a select?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.