Hi all,
I tried so search but couldn't find the answer. My data are as follow:
Table 1
| ID | col1 | col2 | col3 | col4 | col5 |
| 1 | 15 | 152 | 45 | 256 | 65 |
| 2 | 547 | 8 | 2545 | 51 | 1564 |
| 3 | 555 | 545 | 4 | 24545 | 254 |
table 2
| Coef | Coef1 | Coef2 | Coef3 | Coef4 | Coef5 |
I want to multiply every row of the table 1 by the coefficient in table 2, for example for ID 1:
| 1 | 15*Coef1 | 152*Coef2 | 45*Coef3 | 256*Coef4 | 65*Coef5 |
And so on for all rows in table 3 (I have about 10k rows)
How can i do this?
Thanks!
