5 Replies Latest reply: Jul 31, 2015 12:36 PM by jagan mohan rao appala RSS

    how to multiply one field data into another field data?

    Gattamaneni chaitanya

      Table1

      Product,id,location,value

      Apple,1,Hyderabad,10

      LG,2,Bangalore,20.

       

      Table2

      Product,pincode,sales

      Apple,523109,1000

      LG,523107,2000

       

      I want multiply first table value field into second table sales,

      finally requir output

       

      10*1000=10000

      20*2000=20000, how