I need to update a table based on the output of a select.
Select a.fld1, a.fld2 from db.tableA a where a.fld3 = 'blahblah'
The output might be something like
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 - ?