Hi Manfred,
Such a silly thing blocked me, and I was about to write a stored procedure.
Thanks a lot !!
BTW, does anyone knows about a RH7.2 or newer RPM of v7.3? Do I need any
other tools not included in RH7.2 to compile it?
Thrasher
Manfred Koizar wrote:
> On Wed, 02 Oct 2002 19:11:19 +020
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
Hi all
I have two related tables:
CREATE TABLE trans_log (
id serial,
datetimestamp not null,
costnumeric(12,5) NULL
);
CREATE TABLE products_log (
id serial,
trans integer not null references trans_log(id),
costnumeric(12,
