[@affacat Member 16 years, 12 months ago]

this appears to do the trick:

UPDATE

bb_topics

set topic_time =

(SELECT bb_posts.post_time

from bb_posts

where bb_posts.topic_id=bb_topics.topic_id

ORDER BY bb_posts.post_time DESC LIMIT 1)