How to get data from and unrelate table
I had Inventory Table(include price), and a Product Table
In Product Table, there is some variable that may change the material will be used and the number been used
In Inventory Table, there lots differenet material
I want get a cost that, price*quanlity
However, I cannot think a connect between this two table, which make me confused
Becaused, there will be logical or if statment to get which one in connect....
How should I do that?