Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number, prod_group_id number) My intention is to update the columns ist_w and plan_w of the first table (a). a.Plan_w = a.plan * b.percent a.ist_w = .ist * b.percent Every product_id from table a that is in the prod_group of table b shall be updated. Therefor i have to join table b with table c on prod_group_id and table a with table c on product_id. How can I achieve this goal? Thanks in advance!