Hi,
Try it :
UPDATE
MY_TABLE a,
( SELECT
(SUM( t.mins * t.acpm ) / t.rcpmax) AS calc1
(SUM( t.mins * t.acxh ) / t.acxmax) AS calc2
FROM MY_TABLE t
GROUP BY t.source, t.name_id
) q
SET
a.awc = q.calc1,
a.lcr = q.calc2
WHERE a.source = q.source
Pierre
De: "Alberto Ferrari"
À: "Communication channel for MonetDB users"
Envoyé: Jeudi 9 Juin 2016 19:05:25
Objet: Update JOIN?
Is it possible to Update Join in Monet?
I need something like this... (just an example)
UPDATE
MY_TABLE AS a,
( SELECT
(SUM( t.mins * t.acpm ) / t.rcpmax) AS calc1
(SUM( t.mins * t.acxh ) / t.acxmax) AS calc2
FROM MY_TABLE AS t
GROUP BY t.source, t.name_id
) AS q
SET
a.awc = q.calc1,
a.lcr = q.calc2
WHERE a.source = q.source
AND a.name_id = q.name_id
When I try to execute this type of query, I get this error...
syntax error, unexpected AS, expecting SET in: "update sb_rmsv.rmsv_nts_nt_sum_report as"
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
