Update with subselect

[Ben Hood]

Hi,

I can't seem to find any documentation about how to use a subselect in an 
update statement, e.g.

update t1 set c = (
  select t2.a
  from t2
  where t2.id = t1.t2_id
)

Am I missing something here?

Cheers,

Ben