Update Field with function/data from other tables?

Hi all,

I want to update the values of a column with the
result of a function that requires information
from another table. Specifically it needs a
minium and maximum value from another table.

How do I perform the update query?

Below is my attempt but it doesn't work. The
"bhlineid" is my primary key and foreign key in
the 2 tables

UPDATE geo_obs.bhline SET bhline_geom =
CalcBH3dLineMC (minmax.bhlineid,
minmax.srid_original, minmax.from_m, minmax.to_m,
'geo_obs.bhline_surv', 'bhlineid', 'dist_m',
'azim', 'v_inclin',
'bhline_surv_geom', 5.0)
FROM
(SELECT i.bhlineid AS bhlineid, min(i.from_m) AS
from_m,
max(i.to_m) AS to_m, max(c.srid_original) AS
srid_original
FROM geo_obs.bhline_int AS i, geo_obs.bhline AS c
WHERE c.bhlineid=i.bhlineid
GROUP BY i.bhlineid) AS minmax

WHERE geo_obs.bhline.bhlineid = minmax.bhlineid ;

Thanks for any help.

Phillip Allen