0 Replies Latest reply on Jun 6, 2019 9:33 AM by 4014272

    Calculating a column storing its value in a variable. Use the variable further for calculating another column's value in the same row. How can this be performed?

    4014272

      Please help!!

      E.g. Column A is calculated and stored in variable V_A. How? See Below And Column B is calculated using the variable V_A. See below(Second query).

      Just for reference. I know this wont work to fetch the value for the same. Thus please help.

      select q * (select conversion from table_A r where r.country = (select country from Table_B b where b.e_no = (select e_no from Table_B ))) as calc into V_A from Table_B ;

      select V_A * (select markup_PERCENTAGE from table_C r where r.country = (select country from Table_B b where b.e_no = (select e_no from Table_B ))) as calcc into V_B from Table_B ;