How to update a table from a query result of another table related to the first one?

Here is my attempt. What is the correct syntax to achieve this?

UPDATE table_a a    SET a.firstCreationTime = c.created_at  FROM (   SELECT created_at    FROM table_b b    WHERE a.id = b.id    ORDER BY b.created_at ASC    LIMIT 1 ) AS c;