title: MySQL query, 3 tables, t1-t2 then update t3. How can I do this the most efficient way?
body: <p>I have 3 tables inprod, outprod and inventory, they all have Quantity and ProdName in common. I want to subtract the value of Quantity column from inprod and outprod then save it to inventory. Right now I'm still reading for ways on how to do it like Join queries but I want something that will be the best solution for this, simple and clean. </p>