AnsweredAssumed Answered

How to go about querying multiple tables for info

Question asked by MichaelChenetz on Aug 12, 2013
Latest reply on Aug 13, 2013 by MichaelChenetz

Title

How to go about querying multiple tables for info

Post

     Table1:

     --------------------------

     product                      subproduct

     -------------------------------------------------------------------------------------

     prod 1                         subproduct1                10

     prod1                          subproduct2                10

     prod2                          subproduct1                 10

      

     table2

     ------------------------------------

     product                 quantity

     ------------------------------------------------------

     prod1                        100

     prod2                           50

      

     What i want to figure out is if i get 100 of prod1 specified in table2, how would i calculate all of the subproducts that would equate to from table1?

      

     Thanks in advance for your help.

Outcomes