Hi,


I tried to execute the following query in FB but it did not worked (I used to execute these kinkd of queries in Sybase) . I think this kind of queries are not supported in FB. Is there a workaround?

UPDATE product, batch SET product.closing = sum(batch.closing)
WHERE product.id = batch.product_id
GROUP BY batch.product_id;

Thank you.

Ben