5 Replies Latest reply: May 31, 2016 4:05 PM by Onno van Knotsenburg RSS

    Calculated Field from 2 Tables

    Valentin Plekhanov

      hi

      I have 2 tables :

      Tbl1:

      productID

      Price

       

      tbl2:

      QTY

      ProductID

       

      I need to make field as Price*QTY= TOTAL SALES

       

      i make other table as :

      load price

      from Tbl1;

      join

      load  QTY from Tbl2;

       

      but is make many tables and cant make new field.......

       

      how to join is ???