On Wed, 02 Oct 2002 19:11:19 +0200, Thrasher <[EMAIL PROTECTED]> wrote: >UPDATE trans_log t SET t.cost = > (SELECT SUM(p.cost) FROM products_log p WHERE p.trans = t.id)
Thrasher, try it without the table alias t:
UPDATE trans_log SET cost =
(SELECT SUM(p.cost) FROM products_log p
WHERE p.trans = trans_log.id)
Servus
Manfred
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
