That is essentially the Oracle "way" for the join solution suggested by jcolebrand: .... SQL Update column with data from another table.
www.google.com.tw