Hi,

Is there any equivalent command in FB for Truncating Table ?



UPDATE product P
SET closing = (select sum(closing) from batch B
where B.product_id = P.product_id) ;

How do we handle when we need to update one more column in the product table from
table batch?

Thank you

Ben