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!