How to create a MySQL query from two tables?

Question

MySQL

It is necessary to make a calculation according to the formula $x = (w * efr) / rft * (1 + (cos / 10):. And put the data in 'result'.
It is quite simple to make a calculation from one table, but I can’t figure out how to take data from the second one.
I would be very grateful for your help in making a request.

Answer 1

UPDATE Prod SET result = w*eft/(SELECT Forc.rft * (1 + Forc.cos / 10) from Forc where Forc.id=Prod.id)

Answer 2

JOIN on a common field

Answer 3

Join to help you. Join two tables by key field, in your case ID

Answer 4

SELECT * FROM forc LEFT JOIN prod ON prod.id = forc.id