10 Replies Latest reply: Sep 19, 2013 12:17 PM by ScottishPower RSS

    How to find difference in amount between two fields in two different tables



      I am new to PL/SQL. I need to write a procedure to calculate the difference between two columns of two seperate tables. For example:

      I have Table a and Table b. Both with two columns Id and Amount. I need to find the difference of Amount between table a and table b value for each record in table b, store it in variable and then do further operations using that difference. Kindly help me with this.