Postgres Update Join two table

UPDATE amphoe
SET amp_code = province.dept_code || amphoe.amp_code2
FROM province
WHERE province.prov_code2= amphoe.prov_code