hi i have problems updating a field in a table with the value from another table, below is what the 2 table looks like

wk_balances
---------------
customer
alt_ind

wk_customer
----------------
cust_id
industry

i want to link the 2 tables with the wk_balances.customer and wk_customer.cust_id

then i want to replace the values of alt_ind in wk_balances with the values of industry in wk_customer

can someone please help me out with this? Thanks alot!

sincerly
vps

update wk_balances a
set alt_ind =
(select industry
from wk_customer b
where b.cust_id = a.customer)